Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

using excel. show formulas finance question**. Assume that you work for Federal Express (FDX) and are evaluating the purchase of a robot to be used

image text in transcribed
using excel. show formulas
finance question**.
Assume that you work for Federal Express (FDX) and are evaluating the purchase of a robot to be used in the Memphis terminal The base price for the robot is $140,000 and it would cost an additional $30,000 to modify it for FDX's special use. The robot will be placed on the MACRS 3-year class life and would be sold after 3 years for $60,000. The robot would require an $8,000 increase in net operating working capital (spare parts inventory). The increase in net operating working capital will be recovered fully when the robot is salvaged. The project would have no effect on revenues, but is expected to save FDX S60,000 per year in before-tax labor costs. FDX's marginal federal plus state tax rate in Tennessee is 27.5%. Assuming a 12% WACC for FDX, should the robot be purchase and installed? Estimate the initial Cash Flows, Operating Cash Flows and Terminal Cash Flows, and determine the NPV for the project and the IRR for the project. Please set this problem up in your own Excel Spreadsheet. Your spreadsheet should us the following format: Depreciation Schedule:3-year class life, axsaring half year convention Initial Basis Year Dep Rate Depreciation Adj Basis 1 0.33 2 0.45 3 0.15 0.07 Initial Cash Flows atte: CAPEX is total initial capital cost and "Now is the ner increase in working capital Price Modification CAPEX ANOWC -8,000 Initial investment outlay Rahor's operatine cash flows: CFAT Depreciation Taxable income Tax22,54 CEAT 1 60,000 60,000 3 60,000 * Since the tax code no longer allows operating loss carry back, the lowest a firms can be in a given year is zero (0) **Operating losses may be carried forward, thus reducing taxes in year 3 are: (534,500- $16,500)*0.275 54,950 Rahor's Terminal cash flows Salvage value Tax on salvage value Recovery of NOC CEAT S60,000 8,000 **Tax en Salvage (Salvage value-Adjusted Basis)0.275 - NPVS IRR- % Should your firm purchase or reject the new machine? Assume that you work for Federal Express (FDX) and are evaluating the purchase of a robot to be used in the Memphis terminal The base price for the robot is $140,000 and it would cost an additional $30,000 to modify it for FDX's special use. The robot will be placed on the MACRS 3-year class life and would be sold after 3 years for $60,000. The robot would require an $8,000 increase in net operating working capital (spare parts inventory). The increase in net operating working capital will be recovered fully when the robot is salvaged. The project would have no effect on revenues, but is expected to save FDX S60,000 per year in before-tax labor costs. FDX's marginal federal plus state tax rate in Tennessee is 27.5%. Assuming a 12% WACC for FDX, should the robot be purchase and installed? Estimate the initial Cash Flows, Operating Cash Flows and Terminal Cash Flows, and determine the NPV for the project and the IRR for the project. Please set this problem up in your own Excel Spreadsheet. Your spreadsheet should us the following format: Depreciation Schedule:3-year class life, axsaring half year convention Initial Basis Year Dep Rate Depreciation Adj Basis 1 0.33 2 0.45 3 0.15 0.07 Initial Cash Flows atte: CAPEX is total initial capital cost and "Now is the ner increase in working capital Price Modification CAPEX ANOWC -8,000 Initial investment outlay Rahor's operatine cash flows: CFAT Depreciation Taxable income Tax22,54 CEAT 1 60,000 60,000 3 60,000 * Since the tax code no longer allows operating loss carry back, the lowest a firms can be in a given year is zero (0) **Operating losses may be carried forward, thus reducing taxes in year 3 are: (534,500- $16,500)*0.275 54,950 Rahor's Terminal cash flows Salvage value Tax on salvage value Recovery of NOC CEAT S60,000 8,000 **Tax en Salvage (Salvage value-Adjusted Basis)0.275 - NPVS IRR- % Should your firm purchase or reject the new machine

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

School Finance A Policy Perspective

Authors: Allan Odden, Lawrence Picus

6th Edition

1259922316, 9781259922312

More Books

Students also viewed these Finance questions