Question: Fill in the four yellow cells using formulas (simply hard wiring numbers will not receive credit). Find the DFN for this firm. The firm

Fill in the four yellow cells using formulas (simply hard wiring numbers will not receive credit). Find the DFN for this firm. The firm will use Long Term Debt for any financing needs Hellbound Train, Inc. Pro Forma Balance Sheet Hellbound Train, Inc. Pro Forma Income Statement in thousands of dollars in thousands of dollars Assets 2024* 2023 2022 2024* Cash 270.0 270.0 125.0 Sales Extra Cash PLUG Marketable Securities Accounts Receivable 375.0 375.0 1,374.5 1,125.0 250.0 Costs of Goods 875.0 Gross Profits 23,593.8 18,875.0 17,712.2 14,375.0|11,375.0 5,881.6 4,500.0 4,000.0 2023 2022 15,375.0 Inventory 3,583.6 3,125.0 2,125.0 Selling and G&A Expen 2,681.5 2,050.0 1,825.0 PrePaid Expenses 300.0 300.0 100.0 Fixed Expenses Current Assets 5,903.1 5,195.0 3,475.0 Lease Expenses 500.0 375.0 500.0 375.0 500.0 375.0 Before Plant & Equipment Accumulated Depreciation ###### ###### 1,525.0 1,025.0 12,000.0 Depreciation(EBITDA) 725.0 Net Plant & Equipment Long Term Investment Total Assets 1,300.0 1,125.0 ###### ###### 15,650.0 ###### ###### 11,275.0 Depreciation (EBIT) 2,325.1 1,575.0 1,300.0 500.0 300.0 250.0 1,825.1 1,275.0 1,050.0 900.0 Interest Expense 875.0 750.0 Pre-tax Income 1,825.1 400.0 300.0 Tax 730.0 160.0 120.0 Liabilities and Equity Accounts Payable 2024* 2023 1,385.2 1,050.0 2022 Net Income 1,095.0 240.0 180.0 950.0 * forecasted Notes Payable 375.0 375.0 250.0 Notes: Accrued Expenses 426.2 375.0 250.0 Tax Rate 40% 40% 40% Other Current Liabilities Current Liabilities Long term Debt Total Liabilities Common Stock (par $25) Additional Paid-in Capital Retained Earnings Total Stockholders' Equity Total Liabilities and Equity 500.0 500.0 2,686.4 2,300.0 7,250.0 7,250.0 450.0 Shares Outstanding 250,000 1,900.0 Dividend per share 0.48 250,000 0.48 200,000 0.45 6,250.0 interest rate 11.475% Additional Long-term Debt ###### ###### 9,936.4 9,550.0 8,150.0 6,250.0 6,250.0 5,000.0 1,500.0 1,500.0 1,250.0 2,345.0 1,370.0 1,250.0 ###### 9,120.0 7,500.0 15,650.0 *forecast Discretionary Funds Needed Notes: Addition to Plant & Equipment Expected life of new Plant & Equipment Salvage Value additional Depreciation 2,000.0 10 0 200.0 -

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!

Brad is incredibly busy tying up loose ends at the end of the calendar year. His hammock stand business has been doing well but not quite as well as he had hoped. His production level was down...

Penguin, Incorporated, has balance sheet equity of $ 6 . 2 million. At the same time, the income statement shows net income of $ 9 4 8 , 6 0 0 . The company paid dividends of $ 4 9 3 , 2 7 2 and has...

can someone help verify if my answer is correct and explain why if it is not? Assume that today is January 1, 2022, and that you just turned 25 years old. You plan to retire when you turn 65 years...

1. Based on the forecasts above, use the spreadsheet below to construct a pro forma income statement for Idexo over the next five years. What is the annual growth rate of the firm's net income over...

Fill in the four yellow cells using formulas ( simply hard wiring numbers will not receive credit ) . Find the DFN for this firm. The firm will use Long Term Debt for any financing needs

Fill in the four yellow cells using formulas (simply hard wiring numbers will not receive credit). Find the DEN for this firm. The firm will use Long Term Debt for any financing needs Hellbound...

Part C: Break-Even Decisions Return all assumptions to their initial (Part A) values, including returning sales growth back to the average of the previous two years, and returning SG&A/Sales and...

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...

Financial Statement analysis - Homework case number 4. Accounting for Software Revenue Recognition Is Computer Associates Being Too Aggressive? Annual Revenues at Computer Associates (CA) dropped...

I need help answer the questions on this case study based off of the spreadsheet and the case study pdf. Student's Model 04/28/16 ATLAS METALS COMPANY Establishing the Optimal Capital Budget This...

Hello, I need some assistance with this project. I have everything completed except the third and fourth question (located in the instruction project document. 3.)You are a security analyst...

The bar has a non-uniform density 1(x) = 20 x where x is the distance from the left end of the bar. The bar has a length L and can pivot freely (without friction) in a vertical plane, about a...

A box, seperated by a movable ball, has two Compartments are equal, but the pressure are 3P & Po, respectively, when the walls is allowed. to move, the final Pressure in the two compart- ments...

Mr . Rishi Kapoor had an unused allowable capital loss of $ 2 0 , 0 0 0 and an unused non capital loss of $ 1 0 , 0 0 0 during the current fiscal year 2 0 2 4 . Which of the following statements is...

You read in a magazine that economic theory suggests the price of gold should be the same in every country. Describe the theory from international finance that links prices across countries. Explain...

You are one of the responsible managers in ABC. You signed an initial contract with XYZ Company Corporation to carry out a major overhaul of a companys equipment. Ideally, ABC. would like to get the...

Instrumentation & Measurement og Voltmeter ( is used to measure voltage of an electric circuit. The reading of the VOM is shown in Figure Q2a. Given the Full Scale Range of this VOM is set at 50V,...

Your company tries to decide whether to carry out a marketing strategy for a project. The marketing strategy costs $20 million today. Under this marketing strategy, the company will start investing...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

=+c. If appropriate, carry out a test to determine if there is convincing evidence that the mean number of hours spent

=+online in a typical week is greater for male teenagers than for female teenagers. Use a .05 significance level.

=+11.5 Each person in random samples of 247 male and 253 female working adults living in Calgary, Canada was asked how long, in minutes, his or her typical daily commute was (Calgary Herald Traffic...