Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

In your internship with Lewis, Lee, & Taylor Inc

Finance Dec 22, 2020

In your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast the firm's additional funds needed (AFN) for next year. The firm is operating at full capacity. Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year?

Last year's sales = S0 $200,000 Last year's accounts payable $50,000
Sales growth rate = g 40% Last year's notes payable $15,000
Last year's total assets = A0* $132,500 Last year's accruals $20,000
Last year's profit margin = PM 20.0% Target payout ratio 25.0%

Expert Solution

Last year sales(S0)=200000

Forecasted sales growth=40%

Change in sales =last year sales*growth rate

=200000*40% =80000

Next year sales (S1)= 200000+80000= 280000

Assets last year (A0)=132500

spontaneous Liabilities (L0)= Accounts payables+accrual

=50000+20000=70000

Profit margin (PM)= 20%

Dividends payout ratio =25%

External financing Needed Equation = (A0/ S0)*change in Sales - (L0/S0)*change in Sales -(S1*profit margin*(1- payout ratio)

((132500/200000)*80000)-(70000/200000*80000)-(280000*20%*(1-25%))

=-17000

EFN is -17000. It means there is no need of external financing needed next year. So EFN needed next year will be zero (0)

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment