Base year
Cash 22
Account Receivables 111
Inventory 122
Prepaid expenses 23
Total current assets 278
Gross Fixed assets 439
Less: Accumulated depreciation 27
Net fixed assets 412
Total assets: 690
Line of credit 127
Accounts Payable 88
Current portion LTD 53
Total current liabilities 268
Term bank loans 315
Total long term liabilities 315
Common Stock 84
Retained earnings 23
Total Shareholders’ Equity 107
Total liabilities & equity 690
Base year
Net sales 2226
Cost of goods sold 878
Proforma Assumptions: Net sales will decrease by 11%, interest expense is $15.2, depreciation expense is $52, tax expense is #467. Other income statement expenses are proportional to sales. Net income is $589. Proforma year AP days and ACP are same as those in base year. Inventory days is 51 days. GFA will increase by $172 and it will be financed by long-term bank loans. CMLTD for proforma year will be same as in base year. Commond stock is $84. Proforma dividends = $500. Prepaid expenses are proportional to sales. Minimum cash ratio is 1%
Please help me write down the formula to have numbers
Use the inform ation above. What is proforma COGS ?
Use the information above e. What is proforma net sales ?
Use the information above. What is proforma accounts receivable?
Use the information above. What is proforma gross fixed assets ?
Use the information above. What is the proforma long-term bank loans?
Use the information above. What is proforma retained earnings ?
Recall the following
A= Total asset with minimum cash
L= Total liabilities ( except Line of Credit ) + Equity
PLUG= A-L
Suppose that A = 779.7 and L = 761.4 .
Question 1: Then the proforma Line of Credit is …..
Question 2: Then the proforma Cash is …..
Please write down how to calculate it
Thanks a lot
0 comments