Question

In: Finance

I completed chapter 12 problem 13. I need to complete the following in addition to calculating...

I completed chapter 12 problem 13.

I need to complete the following in addition to calculating the project cash flows: compute the NPV and IRR. Given a 10% cost of capital, would you recommend pursuing the project?

You are evaluating a project for The Ultimate recreational tennis racket, guaranteed to correct that wimpy backhand. You estimate the sales price of The Ultimate to be $400 per unit and sales volume to be 1,000 units in year 1; 1,250 units in year 2; and 1,325 units in year 3. The project has a three-year life. Variable costs amount to $225 per unit and fixed costs are $100,000 per year. The project requires an initial investment of $165,000 in assets, which will be depreciated straight- line to zero over the three-year project life. The actual market value of these assets at the end of year 3 is expected to be $35,000. NWC requirements at the beginning of each year will be approximately 20 percent of the projected sales during the coming year. The tax rate is 34 percent and the required return on the project is 10 percent. What will the cash flows for this project be?

Initial Investment

-$165,000

YEAR

0

1

2

3

Sales units

1,000

1,250

1,325

Prices per unit

$400

$400

$400

Sales revenue

$400,000

$500,000

$530,000

Variable cost per unit

$225

$225

$225

Less: Total variable cost

$225,000

$281,250

$298,125

Less: Fixed cost

$100,000

$100,000

$100,000

Less: Depreciation

$55,000

$55,000

$55,000

EBIT

$20,000

$63,750

$76,875

Less: Tax at 34%

$6,800

$21,675

$26,138

Profit after tax

$13,200

$42,075

$50,738

Add: Depreciation

$55,000

$55,000

$55,000

Add: After tax salvage value

-$80,000

$23,100

Change in NWC

-$245,000

-$20,000

-$6,000

$106,000

Cash flows

$48,200.00

$91,075.00

$23,4837.50

Change in NWC:

Sales

$0

$400,000

$500,000

$530,000

NWC

$80,000

$100,000

$106,000

$0

Change in NWC

-$80,000

-$20,000

-$6,000

$106,000

Solutions

Expert Solution


Related Solutions

I need answers for Chapter 5 Problem 28. Render ISBN # 13: 978-0-13-45316-1. Problem Reads: sales...
I need answers for Chapter 5 Problem 28. Render ISBN # 13: 978-0-13-45316-1. Problem Reads: sales of industrial vacuum cleaners at R. Lowenthal supply Co. over the past 13 months are as follows: sales ($1,000s) Month. First row is 11 sales Month January. Need the following a) using a moving average with three periods, determine the demand for vacuum cleaners for next Feb. also (B), (C), (d) answers? this problem can be found on p. 179. in textbook Quantitative Analysis...
I have completed the first 5 parts just need 6&7 Need to complete it by noon...
I have completed the first 5 parts just need 6&7 Need to complete it by noon pacific time Thanks Problem 6-23 (Algo) Make or Buy Decision [LO6-3] Silven Industries, which manufactures and sells a highly successful line of summer lotions and insect repellents, has decided to diversify in order to stabilize sales throughout the year. A natural area for the company to consider is the production of winter lotions and creams to prevent dry and chapped skin. After considerable research,...
Horngren's accounting 12 edition, Chapter 23 Problem 21 Calculating overhead variances MILLS ALLOCATES MANUFACTURING OVERHEAD TO...
Horngren's accounting 12 edition, Chapter 23 Problem 21 Calculating overhead variances MILLS ALLOCATES MANUFACTURING OVERHEAD TO PRODUCTION BASED ON STANDARD DIRECT LABOR HOURS. MILLS REPORTED THE FOLLOWING ACTUAL RESULTS FOR 2018: ACTUAL NUMBER OF UNITS PRODUCED: 1,000 ACTUAL VARIABLE OVERHEAD: $4000 ACTUAL FIXED OVERHEAD: $3,100 ACTUAL DIRECT LABOR HOURS: 1,600 Note: 1. VOH Coat Var. $1,600U Info from E23-18   Murr, Inc. produced 1,000 units of the company's product in 2018, The standard quantity of direct materials was three yards of...
CONO 2463 – Business Statistics Chapter 12 Complete the following parts to calculate (by hand) the...
CONO 2463 – Business Statistics Chapter 12 Complete the following parts to calculate (by hand) the estimated regression equation for x and y. xi yi 15 5 12 7 10 9 7 11 Compute the estimated slope (b1). Compute the estimated intercept (b0). Write the estimated regression question you have calculated. A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). Shown below is a portion of an...
This problem is similar in spirit to Example 12 (in the chapter) and Problem 15 (at...
This problem is similar in spirit to Example 12 (in the chapter) and Problem 15 (at the end of the chapter). I'd strongly suggest that you master those two problems before attempting this problem. Make sure that you draw a high quality, detailed timeline – similar in quality to those in Example 12 and Problem 15. Assume that you wish to begin saving for your child’s college education via making deposits into an investment account that is expected to earn...
This problem is similar in spirit to Example 12 (in the chapter) and Problem 15 (at...
This problem is similar in spirit to Example 12 (in the chapter) and Problem 15 (at the end of the chapter). I'd strongly suggest that you master those two problems before attempting this problem. Make sure that you draw a high quality, detailed timeline – similar in quality to those in Example 12 and Problem 15. Assume that you wish to begin saving for your child’s college education via making deposits into an investment account that is expected to earn...
hey i need perfect answer to following query. Needs 200 words for complete query. i need...
hey i need perfect answer to following query. Needs 200 words for complete query. i need typed solution . Don't post any pic in solution. Describe some important changes you would suggest to a “trebuchet” manufacturer. Explain your improvement in terms of motion in two dimensions.
Problem 13-2 Calculating the amount of temporary and permanent differences and tax entry (LO 13-2, LO...
Problem 13-2 Calculating the amount of temporary and permanent differences and tax entry (LO 13-2, LO 13-4, LO 13-8) The following information pertains to Ramesh Company for the current year: Book income before income taxes $ 106,000 Income tax expense 45,500 Income taxes due for this year 28,000 Statutory income tax rate 35 % The company has one permanent difference and one temporary difference between book and taxable income. Required: Calculate the amount of temporary difference for the year and...
Chapter 12 Problem 3 (Excel functions needed) Consider the project contained in Problem 7 in Chapter...
Chapter 12 Problem 3 (Excel functions needed) Consider the project contained in Problem 7 in Chapter 11 (California Health Center). a. Perform a sensitivity analysis to see how NPV is affected by changes in the number of procedures per day, average collection amount, and salvage value. Remember supplies vary with number of procedures. b. Conduct a scenario analysis. Suppose that the hospital's staff concluded that the three most uncertain variables were number of procedures per day, average collection amount, and...
4) Chapter 13, problem 33 (page 598) Given the following list of items a) classify the...
4) Chapter 13, problem 33 (page 598) Given the following list of items a) classify the items as A, B, or C b) Determine the economic order quantity for each item (round to the nerest whole unit) item est annual demand ordering cost holding cost % unit price h4 20000 50 20 2.5 h5 60200 60 20 4 p6 9800 80 30 28.5 p7 14500 50 30 12 p8 6250 50 30 9 p9 7500 50 40 22 ts 21000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT