{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Fin Forecasting Template No formulas

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

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

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 Liabilities & Equity A/P \$50.00 1 + increase in sales N/P \$120.00 LTD \$400.00 CS \$200.00 RE \$250.00 Total Liab & Eq \$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 Liabilities & Equity 1 + increase in sales A/P \$50.00 N/P \$120.00 LTD \$400.00 CS \$200.00 RE \$250.00 Internal Financing Total Liab & Eq \$1,020.00 forecasted L&E balance Financing needed--External (AFN) AFN: Present Current ratio Target Current Ratio 2.5 Increase in N/P Max Current Liab=current assets/current ratio target -present CL --A/P 60 + N/P 120 =Increase in N/P =Increase in N/P

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

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
Ask a homework question - tutors are online