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 |
- 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:
- Compute the Cash Payback period for the project based on the original projections.
- Compute the net present value of the project based on the original projections.
- Compute the Cash Payback period for the project incorporating James’ estimates of the value of the intangible benefits.
- Compute the net present value of the project incorporating James’ estimates of the value of the intangible benefits.
- 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:
- Compute the cash payback period for the project. (round to two decimal places)
- Compute the net present value for the project (round to the nearest dollar)
- Compute the annual rate of return for the project.
- 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
 ekkarill92 answered 1 year agoRelated SolutionsPlease 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
Latest Questions
ADVERTISEMENT
|