Fin Forecasting Template

Fin Forecasting Template - Percent Incresae in sales Assets...

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

View Full Document Right Arrow Icon
20% Assets Explanation change New Balances Cash $20.00 1 + increase in sales 120% $24.00 A/R $100.00 1 + increase in sales 120% $120.00 Inv $300.00 1 + increase in sales 120% $360.00 P/E $600.00 1 + increase in sales 120% $720.00 Total assets $1,020.00 $1,224.00 A/P $50.00 1 + increase in sales 1.2 $60.00 N/P $120.00 $120.00 LTD $400.00 $400.00 CS $200.00 $200.00 RE $250.00 $250.00 $1,020.00 $1,030.00 $194.00 Internal Financing Present Sales $1,200.00 1+sales increase 120% =New Sales $1,440.00 * profit margin 0.15 =profit $216.00 *Dividend Payout ratio 0.50 Dividends Paid $108.00 =increase in retained earnings $108.00 Explanation Changes New Balances Assets 1 + increase in sales 120% $24.00 Cash $20.00 1 + increase in sales 120% $120.00 A/R $100.00 1 + increase in sales 120% $360.00 Inv $300.00 1 + increase in sales 120% $720.00 P/E $600.00 $1,224.00 Total assets $1,020.00 1 + increase in sales 120% $60.00
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.

Page1 / 6

Fin Forecasting Template - Percent Incresae in sales Assets...

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