Question

In: Finance

Upload an Excel spreadsheet or use the indirect method showing the cash flows of the investment...

  1. Upload an Excel spreadsheet or use the indirect method showing the cash flows of the investment for the € 400.000 investment. Discuss your findings in about 100 words. ( note : you have to assume the numbers and how you want to invest )
  2. Estimate/calculate the overall rate of return (WACC) for the € 400.000 investment based on your personal assumptions. How are you going to finance this investment? Discuss about the capital structure mix you have chosen and how this mix affects the WACC.

Solutions

Expert Solution

Q. Rogers, Inc. is considering the acquisition of new machinery. A consulting company in Mr. Rogers’ neighborhood provided the following information about the economic effects of this acquisition: The cost of the machinery is estimated to be €380 plus installation costs of €20. The new machinery would require fewer workers and less electricity. The projected before-tax costs savings are 90 in the first year, increasing at a 3% rate over the ten-year economic life of the machinery. The new machinery will depreciate using the Straight Line method over ten years to a zero salvage. Rogers, Inc., is subject to an income tax rate of 30%. Equity Investor expected rate of return is 15%, or the company can issue 8% Debenture.

The company has full independence and can choose any mix of Capital Structure mentioned Below.

1. 100% Equity

2. 50% Equity and 50% Debenture

3. 100% Debenture

Conclusion:

Best Cost Structure is 5, 100% debenture since its WACC is lowest, which leads to maximum NPV.

Feel free to ask any Query in Comment Section

Please provide feedback.

Cheers


Related Solutions

When using the spreadsheet (work sheet) for the statement of cash flows, indirect method, entries made...
When using the spreadsheet (work sheet) for the statement of cash flows, indirect method, entries made on the spreadsheet are a. not recorded in to the journal but are posted to the ledger. b. recorded in the journal but not posted to the ledger. c. recorded in the journal and posted to the ledger. d. not recorded in the journal or posted to the ledger.
Statement of Cash Flows (Indirect Method) Use the following information regarding the Lund Corporation to (a)...
Statement of Cash Flows (Indirect Method) Use the following information regarding the Lund Corporation to (a) prepare a statement of cash flows using the indirect method and (b) compute Lund's operating-cash-flow-to-current-liabilities ratio. Accounts payable increase $14,400 Accounts receivable increase 6,400 Accrued liabilities decrease 4,800 Amortization expense 9,600 Cash balance, January 1 35,200 Cash balance, December 31 24,000 Cash paid as dividends 46,400 Cash paid to purchase land 144,000 Cash paid to retire bonds payable at par 96,000 Cash received from...
Statement of Cash Flows (Indirect Method) Use the following information regarding the Lund Corporation to (a)...
Statement of Cash Flows (Indirect Method) Use the following information regarding the Lund Corporation to (a) prepare a statement of cash flows using the indirect method and (b) compute Lund's operating-cash-flow-to-current-liabilities ratio. Accounts payable increase $13,500 Accounts receivable increase 6,000 Accrued liabilities decrease 4,500 Amortization expense 9,000 Cash balance, January 1 33,000 Cash balance, December 31 22,500 Cash paid as dividends 43,500 Cash paid to purchase land 135,000 Cash paid to retire bonds payable at par 90,000 Cash received from...
Statement of Cash Flows—Indirect Method The following statement of cash flows for Shasta Inc. was not...
Statement of Cash Flows—Indirect Method The following statement of cash flows for Shasta Inc. was not correctly prepared. The cash balance at the beginning of the year was $240,000. All other amounts are correct, except the cash balance at the end of the year. Shasta Inc. Statement of Cash Flows For the Year Ended December 31, 20Y9 Cash flows from operating activities: Net income $360,000 Adjustments to reconcile net income to net cash flow from operating activities:    Depreciation 100,800    Gain...
Statement of Cash Flows The indirect method of preparing Cash Flows from Operating Activities in the...
Statement of Cash Flows The indirect method of preparing Cash Flows from Operating Activities in the Statement of Cash Flows starts with accrual net income, and makes adjustments to convert it to net cash provided (used) by operating activities. REQUIRED: Explain how and why the following three items would be handled in the conversion of accrual net income to net cash provided (used) by operating activities. (1) Depreciation Expense (2)   An increase in Accounts Receivable (3) An increase in Wages...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. The Jackpots Dreams Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,600 units that averaged 65 percent complete. Ending work in process inventory was...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. Electric Car Co (ECC). currently manufactures two different types of fully electronic cars in 2021. Type 8Y is a large SUV whereas Type 8W will be the fastest car in the world with 10 rocket thrusters. ECC has decided to use ABC costing instead of traditional costing. The 2021 budget to manufacture these new types include manufacturing overhead...
Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating...
Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating activities. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries. Be sure to complete the heading of the statement. In the operating activities section, use the minus sign to indicate cash outflows, decreases in cash and a net cash outflow, if required. In the investing and financing activities section, use a minus sign...
Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating...
Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating activities. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries. Be sure to complete the heading of the statement. In the operating activities section, use the minus sign to indicate cash outflows, decreases in cash and a net cash outflow, if required. In the investing and financing activities section, use a minus sign...
Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating...
Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating activities. Use the minus sign to indicate cash out flows, cash payments, decreases in cash, or any negative adjustments. The comparative balance sheet of Whitman Co. at December 31, 20Y2 and 20Y1, is as follows:      Dec. 31, 20Y2      Dec. 31, 20Y1 Assets Cash $ 701,950 $ 755,530 Accounts receivable (net) 638,770 582,620 Inventories 968,690 891,480 Prepaid expenses 22,460 26,670 Land 241,470 365,010 Buildings 1,116,100...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT