Company LDC is contemplating on acquiring new machine replace the old one. Year O is when...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Company LDC is contemplating on acquiring new machine replace the old one. Year O is when the new machine will be acquired and the old one disposed. This new machine will operate for 4 years. As the CPA-CMA (istikoy) of the company you are asked by the management for advise on whether to go on with the proposed acquisition. The data attached were given to you for your consideration. You must support your recommendations with appropriate calculations of the Initial Investment Cost (itemized), Present Value of Cash Flows (itemized yearly), Net Present Value, Internal Rate of Return, and Profitability Index. Your recommendation and supporting calculations must be in excel format. Other than the IRR, you are not allowed to use "EXCEL FUNCTION". You may use however excel functions to validate your answer. Caution: Do not forget the tax effect on the transactions. Old Machine New Machine Acquisition Cost Accumulated Dep'n Disposal Price - Old Machine at year 0 Remaining Life - years Sales Commission to agent for disposal of old machine 320,000.00 480,000.00 192,000.00 80,000.00 100,000.00 4 4 10% Asset Removal Cost 2,000.00 95,000.00 Tax Rate 40% 40% Revenue per annum 400,000.00 1,400,000.00 Cash Opex per annum WC to recover at end of life 320,000.00 1,000,000.00 50,000.00 200,000.00 Sales value net of commission at end of life (pretax) 1,500.00 wC Commitment for new machine One-time employee training - year 1 pretax 200,000.00 50,000.00 WACC 10% Employee relocation cost at end of year 4 (pretax) 150,000.00 Company LDC is contemplating on acquiring new machine replace the old one. Year O is when the new machine will be acquired and the old one disposed. This new machine will operate for 4 years. As the CPA-CMA (istikoy) of the company you are asked by the management for advise on whether to go on with the proposed acquisition. The data attached were given to you for your consideration. You must support your recommendations with appropriate calculations of the Initial Investment Cost (itemized), Present Value of Cash Flows (itemized yearly), Net Present Value, Internal Rate of Return, and Profitability Index. Your recommendation and supporting calculations must be in excel format. Other than the IRR, you are not allowed to use "EXCEL FUNCTION". You may use however excel functions to validate your answer. Caution: Do not forget the tax effect on the transactions. Old Machine New Machine Acquisition Cost Accumulated Dep'n Disposal Price - Old Machine at year 0 Remaining Life - years Sales Commission to agent for disposal of old machine 320,000.00 480,000.00 192,000.00 80,000.00 100,000.00 4 4 10% Asset Removal Cost 2,000.00 95,000.00 Tax Rate 40% 40% Revenue per annum 400,000.00 1,400,000.00 Cash Opex per annum WC to recover at end of life 320,000.00 1,000,000.00 50,000.00 200,000.00 Sales value net of commission at end of life (pretax) 1,500.00 wC Commitment for new machine One-time employee training - year 1 pretax 200,000.00 50,000.00 WACC 10% Employee relocation cost at end of year 4 (pretax) 150,000.00
Expert Answer:
Answer rating: 100% (QA)
Answer Solution Initial Cashflows Particulars Amount Acqusition cost of new machine 480000 Disposal ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
You are asked by a client to outline the procedures you would recommend for handling of unclaimed wages. What procedures do you recommend?
-
You are asked by the owner of a medium sized firm manufacturing digital alarm clocks. He thinks there is a market for his product in the BRIC countries. How would you advise him on what to look for...
-
Mega Coal ple has bought land that contains deposits of coal that will be mined. The land is expected to produce coal for five years and then the land will be sold. The initial costs involved in...
-
Dominic and Magalie have been married for five years and have thes children, aged four, seven and nine. Dominic and Magale are diverong and Magalie has been ordered to pay child support, until the...
-
A random sample of 60 accounts gives a sample variance of 1,228. Give a 95% confidence interval for the variance of all accounts.
-
A fence it feet high runs parallel to a tall building and is, feet from it (Figure 23). Find the length of the shortest ladder that will reach from the ground across the top of the fence to the wall...
-
Suppose $X \sim N(0,1)$ and $W_{n} \sim \chi_{n}^{2}$ independently for any positive integer $n$. Let $V_{n}=X / \sqrt{W_{n}} / n$. a. We know $V_{n} \sim t_{n}$. Show that $V_{n}^{2}$ follows an...
-
Dillon Products manufactures various machined parts to customer specifications. The company uses a job-order costing system and applies overhead cost to jobs on the basis of machine-hours. At the...
-
A pool has three water faucet and one drain faucet. The first water faucet can fill up the pool in 3 hours, the second water faucet can fill up the pool in 4 hours, and the third water faucet can...
-
Blair Jokinen is a sales manager for Pearson, one of the top publishing companies in the world. Blair manages 40 sales representatives who visit college professors in Europe. On Saturday mornings,...
-
In the assignment, we consider a dynamic system illustrated by the box diagram 0.5 81 0.2 0.1 0.3 0.2 p3 0.4 0.5 0.2 $2 0.6 Exercise 1. Find the transition matrix M for the system, and explain what...
-
Which one of the following is not a key aspect of financial resource analysis for international companies? differences in tax rates and regulations risk management including currency International...
-
When a firm exchanges a floating interest rate for a fixed interest rate, it is engaged in. a futures contract a forward contract a commodity swap an interest rate swap
-
A soccer team uses cones to outline their field in practices. The volume of each of the cones is 1.05 liters. The height of each cone is equal to 3 times the radius of the base. Estimate the radius...
-
How are melting point and boiling point quantitative properties of a substance? Give examples of how they may be used when describing a substance's quantitative property. For instance, viscosity is a...
-
In the financial planning model external funds needed is equal to changes in
-
A baseball is hit with a speed of 28.0 m/s at an angle of 41.0. It lands on the flat roof of a 14.0 m -tall nearby building.
-
1. As a general strategy, would you recommend that Carl take an aggressive approach to capacity expansion or more of a wait-and-see approach? 2. Should Carl go with the option for one facility that...
-
A business can be valued by capitalizing its earnings stream. How might you use the same idea to value securities, especially the stock of large publicly held companies? Is there a way to calculate a...
-
Calculate an IRR for the project in the previous problem using an iterative technique.
-
Define and discuss (words only, no equations) the concepts of expected return and required return.
-
With reference to Exercise 4.5, find an expression for the distribution function \(F(x)\) of the random variable. Data From Exercise 4.5 k 4.5 Given that f(x): = is a probability distribution for 2x...
-
Given that \(f(x)=\frac{k}{2^{x}}\) is a probability distribution for a random variable that can take on the values \(x=\) \(0,1,2,3\), and 4 , find \(k\).
-
Check whether the following can define probability distributions and explain your answers. (a) \(f(x)=\frac{1}{4}\) for \(x=10,11,12,13\) (b) \(f(x)=\frac{2 x}{5}\) for \(x=0,1,2,3,4,5\) (c)...
Study smarter with the SolutionInn App