Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pls do both, these require excel formulas: ok pls do only this 1 then, sorry A shoe manufacturer is evaluating new equipment that would custom

pls do both, these require excel formulas:
image text in transcribed
image text in transcribed
ok pls do only this 1 then, sorry image text in transcribed
A shoe manufacturer is evaluating new equipment that would custom fit athletic shoes. The new equipment costs $90,000 and will generate $35,000 in net cash flows for five years. \begin{tabular}{l|r|} \hline Equipment cost & $90,000 \\ \hline Annual net cash flow & $35,000 \\ \hline Discount rate & 10% \end{tabular} Required: Determine the break-even time for this equipment. A company is considering a $150,000 investment in machinery with the following net cash flows. The company requires a 10% return on its investments. InitialinvestmentRequiredrateofretum$150,00010% Required: (a) Compute the net present value of this investment. \begin{tabular}{|r|r||l|} \hline Period & Net Cash Flows & PresentValueofNetCashFlows \\ \hline 1 & $10,000 & \\ \hline 2 & 25,000 & Formula must include \\ \hline 3 & 50,000 & the PV function. \\ \hline 4 & 37,500 \\ \hline 5 & 100,000 \\ \hline Totals & \\ \hline Initial investment & \\ \hline Net present value \\ \hline \end{tabular} Verify the value of cell C18 using the NPV function (b) Should the machinery be purchased? A shoe manufacturer is evaluating new equipment that would custom fit athletic shoes. The new equipment costs $90,000 and will generate $35,000 in net cash flows for five years. \begin{tabular}{l|r|} \hline Equipment cost & $90,000 \\ \hline Annual net cash flow & $35,000 \\ \hline Discount rate & 10% \end{tabular} Required: Determine the break-even time for this equipment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

How do patients across cultures prefer to make medical decisions?

Answered: 1 week ago

Question

42. Determine za for the following: a. a .0055 b. a .09 c. a .663

Answered: 1 week ago