Question

In: Accounting

ACG 2071 – Comprehensive Problem IV When submitting the completed project, please show all work and...

ACG 2071 – Comprehensive Problem IV

When submitting the completed project, please show all work and number each answer accordingly.

When calculating the NPV use the following five columns (use for ALL NPV calculations):

Item

Year(s)

Cash Flow

Discount Factor

Present Value of Cash Flows

  1. Tony Skateboards is considering building a new plant. James Bott, the company’s marketing manager, is an enthusiastic supporter of the new plant. Michele Martinez, the company’s chief financial officer, is not so sure that the plant is a good idea. Currently the company purchases its skateboards from foreign manufacturers.   The following figures ere estimated regarding the construction of the new plant.

Cost of plant

$4,000,000.00

Estimated useful life

15 years

Annual cash inflows

$4,000,000.00

Salvage value

$2,000,000.00

Annual cash outflows

$3,550,000.00

Discount rate

11%

James Bott believes that these figures understate the true potential value of the plant. He suggests that by manufacturing its own skateboards the company will benefit from a “buy American” patriotism that he believes is common among skateboarders. He also notes that the firm has had numerous quality control problems with the skateboards manufactured by its suppliers. He suggests that the inconsistent quality has resulted in lost sales, increased warranty claims, and some costly lawsuits. Overall, he believes sales will be $200,000 higher than the projected above, and that the savings from lower warranty costs and legal costs will be $80,000 per year.

Required:

  1. Compute the Cash Payback period for the project based on the original projections.
  2. Compute the net present value of the project based on the original projections.
  3. Compute the Cash Payback period for the project incorporating James’ estimates of the value of the intangible benefits.
  4. Compute the net present value of the project incorporating James’ estimates of the value of the intangible benefits.
  5. Comment on your findings.

2. The partnership of Michele and Mark is considering the following long-term capital investment proposal. Relevant data on the project is listed below. Salvage value is expected to be zero for the project. Depreciation is computed by the straight-line method. The company’s rate of return is the company’s cost of capital which 12%.

Brown

Capital Investment

$200,000.00

Annual Net Income:

Year 1

$25,000.00

Year 2

$16,000.00

Year 3

$13,000.00

Year 4

$10,000.00

Year 5

$8,000.00

Total

$72,000.00

Required:

  1. Compute the cash payback period for the project. (round to two decimal places)
  2. Compute the net present value for the project (round to the nearest dollar)
  3. Compute the annual rate of return for the project.
  4. Compute the profitability index for the project.

Solutions

Expert Solution

a) Cash Payback Period = (Total Initial Investments- Salvage Value)/Net Annual Cash Flows

Cash Payback Period = (4000000-2000000)/(4000000-3550000)

Cash Payback Period = 4.44 years

b)

Item Years Cash Flow Discount Factor Present Value of Cash Flows
Cost of Plant 0 $ (4,000,000.00) 1.00 $                       (4,000,000.00)
Net Cash Flows (4000000-3550000) 1 $      450,000.00 1.11 $                            405,405.41
Net Cash Flows (4000000-3550000) 2 $      450,000.00 1.23 $                            365,230.09
Net Cash Flows (4000000-3550000) 3 $      450,000.00 1.37 $                            329,036.12
Net Cash Flows (4000000-3550000) 4 $      450,000.00 1.52 $                            296,428.94
Net Cash Flows (4000000-3550000) 5 $      450,000.00 1.69 $                            267,053.10
Net Cash Flows (4000000-3550000) 6 $      450,000.00 1.87 $                            240,588.38
Net Cash Flows (4000000-3550000) 7 $      450,000.00 2.08 $                            216,746.28
Net Cash Flows (4000000-3550000) 8 $      450,000.00 2.30 $                            195,266.92
Net Cash Flows (4000000-3550000) 9 $      450,000.00 2.56 $                            175,916.15
Net Cash Flows (4000000-3550000) 10 $      450,000.00 2.84 $                            158,483.02
Net Cash Flows (4000000-3550000) 11 $      450,000.00 3.15 $                            142,777.49
Net Cash Flows (4000000-3550000) 12 $      450,000.00 3.50 $                            128,628.37
Net Cash Flows (4000000-3550000) 13 $      450,000.00 3.88 $                            115,881.41
Net Cash Flows (4000000-3550000) 14 $      450,000.00 4.31 $                            104,397.67
Net Cash Flows (4000000-3550000)+2000000 15 $ 2,450,000.00 4.78 $                            512,060.65
NPV $                          (346,100.00)

c)

Cash Payback Period = Total Initial Investments/Net Annual Cash Flows

Cash Payback Period = (4000000-2000000)/(4200000-3470000)

Cash Payback Period = 2.74 years

d)

Item Years Cash Flow Discount Factor Present Value of Cash Flows
Cost of Plant 0 $ (4,000,000.00) 1.00 $                       (4,000,000.00)
Net Cash Flows (4200000-3470000) 1 $      730,000.00 1.11 $                            657,657.66
Net Cash Flows (4200000-3470000) 2 $      730,000.00 1.23 $                            592,484.38
Net Cash Flows (4200000-3470000) 3 $      730,000.00 1.37 $                            533,769.71
Net Cash Flows (4200000-3470000) 4 $      730,000.00 1.52 $                            480,873.61
Net Cash Flows (4200000-3470000) 5 $      730,000.00 1.69 $                            433,219.47
Net Cash Flows (4200000-3470000) 6 $      730,000.00 1.87 $                            390,287.81
Net Cash Flows (4200000-3470000) 7 $      730,000.00 2.08 $                            351,610.64
Net Cash Flows (4200000-3470000) 8 $      730,000.00 2.30 $                            316,766.34
Net Cash Flows (4200000-3470000) 9 $      730,000.00 2.56 $                            285,375.08
Net Cash Flows (4200000-3470000) 10 $      730,000.00 2.84 $                            257,094.67
Net Cash Flows (4200000-3470000) 11 $      730,000.00 3.15 $                            231,616.82
Net Cash Flows (4200000-3470000) 12 $      730,000.00 3.50 $                            208,663.80
Net Cash Flows (4200000-3470000) 13 $      730,000.00 3.88 $                            187,985.41
Net Cash Flows (4200000-3470000) 14 $      730,000.00 4.31 $                            169,356.22
Net Cash Flows (4200000-3470000)+2000000 15 $ 2,730,000.00 4.78 $                            570,581.87
NPV $                        1,667,343.48

e) Based on the initial observation, the NPV is negative which makes this project unfeasible, however based on the new inputs from James, the NPV become positive and the Cashback payback period is also lesser than the initial observation

2 a)

Year Capital Investment Net Income Depreciation Net Cash Flows Cumulative Cash Flows from Year 1 onwards
Year 0 $               (200,000.00) $                                                                     -   $                -   $ (200,000.00) $                                                                           -  
Year 1 $                                 -   $                                                      25,000.00 $ 40,000.00 $      65,000.00 $                                                             65,000.00
Year 2 $                                 -   $                                                      16,000.00 $ 40,000.00 $      56,000.00 $                                                           121,000.00
Year 3 $                                 -   $                                                      13,000.00 $ 40,000.00 $      53,000.00 $                                                           174,000.00
Year 4 $                                 -   $                                                      10,000.00 $ 40,000.00 $      50,000.00 $                                                           224,000.00
Year 5 $                                 -   $                                                         8,000.00 $ 40,000.00 $      48,000.00 $                                &nb

Related Solutions

Please answer the problem below for all parts. Please show all work and write clearly. Thanks....
Please answer the problem below for all parts. Please show all work and write clearly. Thanks. (Apply total probability and Bayes’ rules) A large industrial firm uses three local motels to provide overnight accommodations for its clients. From past experience it is known that 22% of the clients are assigned rooms at the Ramada Inn, 50% at the Sheraton, and 28% at the Lakeview Motor Lodge. If the plumbing is faulty in 5% of the rooms at the Ramada Inn,...
PLEASE SHOW ALL WORK. THANK YOU Holly is considering a new project. The project will require...
PLEASE SHOW ALL WORK. THANK YOU Holly is considering a new project. The project will require $500,000 for new fixed assets, $208,000 for additional inventory, and $36,000 for additional accounts receivable. Short-term debt is expected to increase by $165,000. The project has a 6-year life. The fixed assets will be depreciated straight-line to a zero book value over the life of the project. At the end of the project, the fixed assets can be sold for 20 percent of their...
Please answer all parts of the question. Please show all work and all steps. 1a.) Show...
Please answer all parts of the question. Please show all work and all steps. 1a.) Show that the solutions of x' = arc tan (x) + t cannot have maxima 1b.) Find the value of a such that the existence and uniqueness theorem applies to the ivp x' = (3/2)((|x|)^(1/3)), x(0) = a. 1c.) Find the limits, as t approaches both positive infinity and negative infinity, of the solution Φ(t) of the ivp x' = (x+2)(1-x^4), x(0) = 0
-PLEASE SHOW ALL WORK- For this problem, carry at least four digits after the decimal in...
-PLEASE SHOW ALL WORK- For this problem, carry at least four digits after the decimal in your calculations. Answers may vary slightly due to rounding. A random sample of medical files is used to estimate the proportion p of all people who have blood type B. (i) If you have no preliminary estimate for p, how many medical files should you include in a random sample in order to be 85% sure that the point estimate p̂ will be within...
Show that ?̅ is an unbiased estimator for ?. ( please show all work completely)
Show that ?̅ is an unbiased estimator for ?. ( please show all work completely)
Show all work please Calculate the price and duration for the following bond when the going...
Show all work please Calculate the price and duration for the following bond when the going rate of interest is 4%. The bond offers 3.5% coupon rate, matures in 3 years and has a par value of $1,000. Show full calculations and fill the table below. YR PV of $ 1 Bond Cash Flows PV (Cash Flows) Year * Present Value of Cash Flow 1 2 3 3 Total Price = Duration    What would be the new price if...
Please solve the recurrence relation by finding the explicit formula of each problem. Show all work,...
Please solve the recurrence relation by finding the explicit formula of each problem. Show all work, thanks! A. ck = 6ck-1 - 9ck-2      k≥2,   c0 =1, c1=3 B. dk = 2dk-1 +k                       k≥1,   d0 =1, d1=3 C. ak = 3ak-1 + 2                         k≥1,   a0 =3 D. bk = -bk-1 + 7bk-2    k≥2,   b0 =1, b1=4
Please show all work: Assignment: You will be answering problems #1 - #4. For each problem,...
Please show all work: Assignment: You will be answering problems #1 - #4. For each problem, you will need to complete parts A through F. Please make sure you answer each part completely and you offer justification where necessary. Do all work "by hand" (not using StatCrunch) as good practice for your next exam! A) Write the claim mathematically and state the null and alternative hypotheses. B) Determine whether the hypothesis test is left-tailed, right-tailed, or two tailed and whether...
Please solve the following breakeven analysis problem and show all systems of equations and work. (Excel...
Please solve the following breakeven analysis problem and show all systems of equations and work. (Excel solver is not neccessary for this problem) Jim and Pam are going to Culinary School! There are a group of students at the school who are drug dealers, and the Captain has received information that they are looking to start selling a dangerous new street drug to the residents of the town nearby. Jim and Pam infiltrate this group and propose that they use...
Please show work. A student spends all of her income on pizza and books. When pizzas...
Please show work. A student spends all of her income on pizza and books. When pizzas cost $3 each and books cost $10 each, she consumed 30 pizzas and 3 books per month. The price of pizzas fell to $2.90 each while the price of books rose to $11 each. The price change a. made her worse off. b. left her exactly as well off as before. c. left her at least as well off as before and possibly helped...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT