Question: 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:
 pls do both, these require excel formulas: ok pls do only
this 1 then, sorry A shoe manufacturer is evaluating new equipment that
ok pls do only this 1 then, sorry would custom fit athletic shoes. The new equipment costs $90,000 and will

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!