Help! The excel file is what I have come up with, but I'm stuck.

Pizza Huh Inc.'s financial statements are shown below. Income Statement Sales Operating costs EBITDA Depreciation EBIT Interest EBT Taxes (40%) Net income Dividends: Addition to RE: 201 5 $3,600,0 3,135,7 00 20 464,2 80 144,0 00 320,2 80 18,2 80 302,0 00 120,8 00 181,2 00 108,000 73,200 Balance Statement as of December 31, 2015 Cash $180,000 Receivables 360,000 Inventories 720,000 Total current assets 1,260,000 Net Fixed assets 1,440,000 Total assets $2,700,000 Accounts payable $360,000 Notes payable 156,000 Accruals 180,000 Total current liabilities 696,000 Long-term bonds 200,000 Common stock 1,600,000 Retained earnings 204,000 Common equity 1,804,000 Total liab. and equity $2,700,000 Pizza Huh's financial manager predicts that sales will increase by 10% in 2016, and that 2016 dividends will decrease to $100,000. Pizza Huh's short-term and longterm interest rates in 2016 will be 3.5% and 4.5% respectively. The financial manager also decides on the following ratios for the investor supplied capital in 2016: Notes payable/Investor-supplied capital 10% Long-term bonds/Investor-supplied capital 15% Common equity/Investorsupplied capital 75% 1 The manager predicts that the receivables/sales ratio will be 15% in 2016 as the company will incur more credit sales. The 2016 ratios for costs, cash, payables, inventories, fixed assets, and accruals will be the same as previous year. Construct the pro forma financial statements using the FFS approach. 2 Income Statement 2015 2016 Forecast Sales Operating costs EBITDA Depreciation EBIT Interest $3,600,000 3,135,720 464,280 144,000 320,280 18,280 same as ratio Inputs $3,960,000 Operating Ratios: $3,449,292 Growth rate in Sales $510,708 110% Op Costs except dep/sales 87% $158,400.00 Dep/Net PPE 10% $352,308.00 Cash/Sales $26,383.50 5% AR/Sales 15% $325,924.50 Inv/Sales 20% $130,369.80 Net PPE/Sales 40% $195,554.70 AP/Sales 10% interest on notes $9,009.00 Interest on bonds $17,374.50 EBT Taxes (40%) Net income Dividends: Addition to RE: 302,000 120,800 181,200 108,000 73,200 100,000 $95,554.70 Accruals/Sales 5% Tax Rate Financing Data: Balance Statement as of December 31, 2015 Receivables Inventories Total current assets Net Fixed assets Total assets $180,000 360,000 720,000 1,260,000 1,440,000 $2,700,000 10% LT bonds/Investor-Sup Cap Cash Notes Payable/Investor-Sup Cap 15% $198,000 Pref. Stock/Investor-Sup Cap $594,000 Common Equity/Investor-Sup Cap $792,000 Interest Rate on Notes Payable 3.50% $1,584,000 Interest Rate on LT Bonds 4.50% $1,584,000 Dividend rate on PFD stock $3,168,000 Target dividend payout ratio Investor Supplied Capital Accounts payable Notes payable Accruals Total current liabilitie Long-term bonds Common stock Retained earnings Common equity Total liab. and equity $360,000 156,000 180,000 696,000 200,000 1,600,000 240,000 1,804,000 2,700,000 $396,000 $257,400 $198,000 $851,400 $386,100 $1,930,500 75% $2,574,000