Add expense descriptions to rows e through i and add additional rows if needed. Take "Budgeted" column from table 6 part 4.
|
Budgeted |
Actual |
||
Conversion Rate |
|
Conversion Rate |
|
|
Local Currency |
Dollars |
Local Currency |
Dollars |
|
a. Total months sales |
|
|
|
|
b. Cost of goods sold |
|
|
|
|
c. Gross Profit c=a-b |
|
|
|
|
Operating expenses |
||||
d. Salaries |
|
|
|
|
e. |
|
|
|
|
f. |
|
|
|
|
g. |
|
|
|
|
h. |
|
|
|
|
i. |
|
|
|
|
j. Total operating expenses j=d+e+f+g+h+i |
|
|
|
|
k. Pretax Income k=c-j |
|
|
|
|
l. Profit Tax escrow |
|
|
|
|
m. Other escrows |
|
|
|
|
n. Net Income n=k-l-m |
|
|
|
|
o. Loan Payment |
|
|
|
|
p Fixed Monthly Support Fee |
|
|
|
|
q. Net Profit q=n-o-p |
|
|
|
|
r. Cash on hand at the beginning of the month |
|
|
|
|
s. Cash now on hand s=r+q |
|
|
|
|
|
|
|
|
|