Fin Forecasting Template

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

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Percent Incresae in sales 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 Liabilities & Equity 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 Total Liab & Eq $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 Liabilities & Equity 1 + increase in sales 120% $60.00 A/P $50.00 $120.00 N/P $120.00 $400.00 LTD $400.00 $200.00 CS $200.00 Internal Financing $108.00 $358.00 RE $250.00 $1,138.00 Total Liab & Eq $1,020.00
Image of page 1

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

View Full Document Right Arrow Icon
$86.00 AFN: Present Current ratio 2.8 Target Current Ratio 2.5 Increase in N/P Max Current Liab=current assets/current ratio target $201.60 -present CL --A/P 60 + N/P 120 $180.00 =Increase in N/P $21.60 =Increase in N/P $21.60 Explanation Changes New Balances Assets
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern