Fin Forecasting Template No formulas

Fin Forecasting Template No formulas - Percent Increase in...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Percent Increase in Sales 20.0% Assets Explanation change New Balances Cash $20.00 1 + increase in sales A/R $100.00 1 + increase in sales Inv $300.00 1 + increase in sales P/E $600.00 1 + increase in sales Total assets $1,020.00 forecasted asset balance A/P $50.00 1 + increase in sales N/P $120.00 LTD $400.00 CS $200.00 RE $250.00 $1,020.00 forecasted L&E balance Financing needed Internal Financing Present Sales $1,200.00 1+sales increase 120% =New Sales * profit margin 0.15 =profit *Dividend Payout ratio 0.50 Dividends Paid =increase in retained earnings Assets Explanation Changes New Balances Cash $20.00 1 + increase in sales $0.00 A/R $100.00 1 + increase in sales Inv $300.00 1 + increase in sales P/E $600.00 1 + increase in sales Total assets $1,020.00 forecasted asset balance 1 + increase in sales A/P $50.00 N/P $120.00 LTD $400.00 CS $200.00 RE $250.00 Internal Financing $1,020.00 forecasted L&E balance Financing needed--External
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/07/2010 for the course FIN 3162N taught by Professor Spencer during the Spring '10 term at Dowling.

Page1 / 2

Fin Forecasting Template No formulas - Percent Increase in...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online