Question: 2. Determine whether or not the financing needed exceeds the limit on the revolver account. 2a. If the needed financing exceeds the revolver account limit,

2. Determine whether or not the financing needed exceeds the limit on the revolver account.

2a. If the needed financing exceeds the revolver account limit, the revolver maxxes out and any additional needed financing is at the additional LT debt rate.

(please show any excel formulas needed)

2. Determine whether or not the financing needed exceeds the limit on

I J K L M N O A 1 Without the project INCOME STATEMENT Revenue COGS* SGA** EBIT*** D E F G H Hist Proj Year 0 Year 1 Year 2 Year 3 Year 4 160.0 171.2 183.2 196.0 209.7 80.0 80.5 86.1 92.1 29.0 29.1 31.1 33.3 35.7 51.0 61.6 65.9 70.6 75.5 Required return = 12% Revenue growth = 7% COGS = 47% of sales SGA = 17% of sales CA = 57% of sales LTA, Debt, and C/S will experience no change. 8 2.1 9 - 10 # Revolver Limit Interest: Excess cash Interest: Revolver Interest: Debt Interest: Add'l LTD EBT**** 3.0% 8.0% 9.0% 0.0 0.0 0.0 19.8 0.8 0.0 19.8 1.5 0.0 19.8 2.2 0.0 19.8 31.8 41.8 47.0 52.2 57.9 40.0% Tax Net income 12.7 19.1 16.7 25.1 18.8 28.2 20.9 31.3 23.2 34.7 19 0.0 Hist Proj Year 0 Year 1 Year 2 Year 3 Year 4 27.5 48.9 72. 9 99.8 100.0 97.6 104.4 111.7 119.5 350.0 350.0 350.0 350.0 350.0 450.0 475.1 503.3 534.6 569.4 BALANCE SHEET Excess cash Current assets Long-term assets Total assets 21 | 22 23 0.0 220.0 0.0 220.0 0.0 220.0 0.0 220.0 0.0 220.0 Revolver Debt Additional LT Debt Common stock Retained earnings Total liabs and equity 100.0 130.0 450.0 100.0 155.1 475.1 100.0 183.3 503.3 100.0 214.6 534.6 100.0 249.4 569.4 31 I J K L M N O A 1 Without the project INCOME STATEMENT Revenue COGS* SGA** EBIT*** D E F G H Hist Proj Year 0 Year 1 Year 2 Year 3 Year 4 160.0 171.2 183.2 196.0 209.7 80.0 80.5 86.1 92.1 29.0 29.1 31.1 33.3 35.7 51.0 61.6 65.9 70.6 75.5 Required return = 12% Revenue growth = 7% COGS = 47% of sales SGA = 17% of sales CA = 57% of sales LTA, Debt, and C/S will experience no change. 8 2.1 9 - 10 # Revolver Limit Interest: Excess cash Interest: Revolver Interest: Debt Interest: Add'l LTD EBT**** 3.0% 8.0% 9.0% 0.0 0.0 0.0 19.8 0.8 0.0 19.8 1.5 0.0 19.8 2.2 0.0 19.8 31.8 41.8 47.0 52.2 57.9 40.0% Tax Net income 12.7 19.1 16.7 25.1 18.8 28.2 20.9 31.3 23.2 34.7 19 0.0 Hist Proj Year 0 Year 1 Year 2 Year 3 Year 4 27.5 48.9 72. 9 99.8 100.0 97.6 104.4 111.7 119.5 350.0 350.0 350.0 350.0 350.0 450.0 475.1 503.3 534.6 569.4 BALANCE SHEET Excess cash Current assets Long-term assets Total assets 21 | 22 23 0.0 220.0 0.0 220.0 0.0 220.0 0.0 220.0 0.0 220.0 Revolver Debt Additional LT Debt Common stock Retained earnings Total liabs and equity 100.0 130.0 450.0 100.0 155.1 475.1 100.0 183.3 503.3 100.0 214.6 534.6 100.0 249.4 569.4 31

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please read the attachment chapters and answer the following questions with at least 50 words. Depreciation discussion What are the various methods of determining depreciation and amortization...

Assume that you are preparing to confirm accounts receivable at December 31, 2022, which is one month prior to the fiscal year-end of January 31, 2023. The book value of gross accounts receivable is...

Just Question 1~3 with full explanation including organization, facts, issues, applicable literature (GAAP, IFRS), analysis, and conclusion. Thanks! Case 10-2 Ida's Impairment Ida Inc. (Ida) is a...

Management 4390 Exercise: Applying the Content of Chapter 3 to your Company 1. Which of the five competitive forces is creating the strongest competitive pressures for your digital camera company? 2....

Can anyone help me with this or already have the solution this whole Finance Workbook for Madura Personal Finance, Third Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK INDEX Chapter...

i need all Journal entries for chapter 4 only see the file Instructions City of Bingham Computerized Cumulative Problem For use with McGraw-Hill/Irwin Accounting for Governmental & Nonprofit Entities...

I posted two annual reports one is Microsoft and other one is Game Stop can i plzz know what are the similarity and difference Dividends we paid cast dividends of $40.5 million, $17.4 milion and...

Locate the 2020 Annual Reports (Form 10-K) for Tesla, Inc and Ford Motor Company on the Investor Relations section of the companies websites or sec.gov/edgar. Be sure to use the audited financial...

Shaw Communications Inc. is a diversified Canadian communications company that provides cable television, Internet, digital phone, telecommunications, and satellite direct-to-home services to more...

Does Helm have a valid discrimination claim under Title VII against the State of Kansas?

Tom is the majority shareholder in Ribble Ltd and is also a director. Recently Tom sold freehold land belonging to the company to his wife who is also a director, and two months later his wife sold...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

3-7 Why are disruptive technologies so difficult for even the companies that develop them?

3-6 It has been said that the advantage that leading- edge retailers such as Dell and Walmart have over their competition isnt technology; its their management. Do you agree? Why or why not?

3. Are there any disadvantages to mining customer data? Explain your answer. With the amount of data available to companies doubling every year, new sources of data, and innovations in data...