Help me

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. Answer all the questions. Please do not just answer one. Thank you so much

Question 1: Use the information above. What is proforma COGS ?

a) 1149

b) 966

c) 1073

d) 781

Question 2: Use the information above . What is proforma net sales ?

a) 2226

b) 1891

c) 1981

d) 2449

Question 3) Use the information above. What is proforma accounts receivable?

a) 90.8

b) 98.8

c) 122.9

d) 111.9

4) Use the information above. What is proforma gross fixed assets ?

a) 270

b) 611

c) 520

d) 580

5) Use the information above. What is the proforma long-term bank loans?

a)475

b) 295

c) 434

d) 398

6) Use the information above. What is proforma retained earnings ?

a) 112.1

b) 230.1

c) 138.1

d) 405.1