
Please solve and show all working
Answer: 4
Compute Effective annual cost (EAC)
If sold in Year 1
Year Cahflows PV factor@12% PV cash flows
0 $ -14,000.00 1 $ -14,000.00
1 $ 4,600.00 0.892857143 $ 4,107.14
$ -9,892.86
EAC = -9892.86/0.89286 $ -11,080.00
If sold in Year 2
Year Cahflows PV factor@12% PV cash flows
0 -14000 1 -14000
1 -3400 0.892857143 -3035.714286
2 1400 0.797193878 1116.071429
1.69005102 -15919.64286
EAC = -15919.6429/1.6900 $ -9,419.62
If sold in Year 3
Year Cahflows PV factor@12% PV cash flows
0 -14000 1 -14000
1 -3400 0.892857143 -3035.714286
2 -4600 0.797193878 -3667.091837
3 -1800 0.711780248 -1281.204446
2.401831268 -21984.01057
EAC = -21984.0106/2.40183 $ -9,153.02
If sold in Year 4
Year Cahflows PV factor@12% PV cash flows
0 -14000 1 -14000
1 -3400 0.892857143 -3035.714286
2 -4600 0.797193878 -3667.091837
3 -5800 0.711780248 -4128.325437
4 -5200 0.635518078 -3304.694008
3.037349347 -28135.82557
EAC = -28135.8256/3.0373 $ -9,263.28
If sold in Year 5
Year Cahflows PV factor@12% PV cash flows
0 -14000 1 -14000
1 -3400 0.892857143 -3035.714286
2 -4600 0.797193878 -3667.091837
3 -5800 0.711780248 -4128.325437
4 -7200 0.635518078 -4575.730165
5 -8300 0.567426856 -4709.642902
3.604776202 -34116.50463
EAC = -34116.5046/3.60477 $ -9,464.25
If asset was sold at the end of year 3, it will leads to lower
EAC.
Therefore, the asset shall be kept for 3 years
So, economic service life of the asset is 3 years
Please solve and show all working 4. The following table summarizes the financial data for a...
Please help me solve 4-8
Use the following table to answer questions 1 – 6. The wacc is 10% for all projects in this table. Year Project A -1,000 1,000 Project B -1,000 300 400 500 600 Project C -1,000 550 450 350 250 Project D -1,000 600 800 1. Compute the Net Present Value (NPV), Internal Rate of Return (IRR), Profitability Index (PI), and Payback Period (PB) for each project: Project A Project B Project C Project D WACC...
PLEASE SHOW (STEP-BY-STEP) HOW YOU WOULD SOLVE TO FIND THE
ANSWER.
REPLACEMENT ANALYSIS The Oviedo Company is considering the purchase of a new machine to replace an obsolete one. The machine being used for the operation has a book value and a market value of zero. However, the machine is in good working order and will last at least another 10 years. The proposed replacement machine will perform the operation so much more efficiently that Oviedo's engineers estimate that it...
MUST SHOW ALL CORRECT EXCEL FORMULAS
XUR 5 + Calculating NPV - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in Calibri 11 - A A 23 Paste BIU E! - A % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font . A1 fx A B C D E F G H 1 2 Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of...
Please show all the steps you've done to reach the final answer. I am trying to learn, so please show your work. Typing your answer is important. 1) A metal plating company is considering four different methods for recovering by-product heavy metals from a manufacturing site’s liquid waste. The investment costs and annual net incomes associated with each method have been estimated. All methods have an 8-year life; the MARR is 11% per year, and an AW-based ROR analysis is...
Data Table MI (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a ti spreadsheet.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes 10 years 10% 18% 14% 14% 45% 18% 4 5% 5% 5% 5% 10 Print Done P11-29 (similar to Question Help Integrative Investment decision Holliday Manufacturing is considering the replacement of an existing machine. The new machine costs $129 million...
Please solve, show work, and
give detail explanation
4. A firm is considering a new three-year expansion project that requires an initial asset investment of $2.7 million. The fixed asset falls into the three-year MACRS class. The project is estimated to generate $2,080,000 in annual sales, with costs of $775,000. The project requires an initial investment in net working capital of $300,000 and the fixed asset will have a market value of $210,000 at the end of the project. If...
Please solve these two finance questions
ns and Problems Calculating Project NPV Flatte Restaurant is considering the purchase of a $7.500 soume maker. The souflé maker has an economic life of five years and will be fully 1. depreciated by the straight-line method. The machine will produce 1,300 soufflés per year, with each costing $2.15 to make and priced at $5.25. Assume that the discount rate is 14 percent and the tax rate is 34 percent. Should the company make...
please help me solve the following 6!! please only attempt if you
can solve ALL 6! thank you so much for your time, will rate! ?
The expected return on an asset you currently own is 12% and the required return is 9%. You should probably Owait and see what happens to actual returns before making a decision short the asset now. buy more of the asset now ignore the expected return sell the asset now. Which of the following...
Hi,
Could you show me how to solve #13 for NPV using only a financial
calculator please?
Thank you very much in advance!
the proj NPV and Modified A 01. ICA I! Year 2? Year 3? What is the new NPV? Modified ACRS LLO1] In the previous problem, suppose the fixed asset falls into the three-year MACRS class. All the other facts are the same. What roiect's Year 1 net cash flow now? Year 2? Year 3? What is the...
Homework for Chapter 12: Problem #2 in the text (Chapter 12) NOTE: PLEASE USE THE ATTACHED EXCEL FILE TITLED Homework for Chapter 12_Excel" TO SOLVE THE FOLLOWING PROBLEM. Tough Steel, Inc. is a processor of stainless steel products. The firm is considering replacing an old stainless steel tube-making machine for a more cost-effective machine that can meet the firm's quality standards. • The old machine was acquired 2 years ago at an installed cost of $500,000. It has been depreciated...