Question: I really need help with this, I need help with the equations for all the excel tabs. I need the npv function not the pv.

I really need help with this, I need help with the equations for all the excel tabs. I need the npv function not the pv. It would be amazing if someone can help. Thank you so so so much!

A B C E F G H 1 Machine 1 Machine 2 2 Discount rate 3 Growth rate 4 NPV 5 IRR 6 Cash flows: 7 Start 6 Month 1 9 Month 2 10 Month 3 11 Month 4 12 Month 5 13 Month 6 14 Month 7 15 Month 8 16 Month 9 17 Month 10 18 Month 11 19 Month 12 20 Month 13 21 Month 14 22 Month 15 23 Month 16 24 Month 17 25 Month 18 26 Month 19 27 Month 20 28 Month 21 29 Month 22 30 Month 23 31 Month 24 32 Month 25 33 Month 26 34 Month 27 35 Month 28 36 Month 29 37 Month 30 36 Month 31 39 Month 32 40 Month 33 41 Month 34 42 Month 35 43 Month 36 14 Month 37A B C 45 Month 38 46 Month 39 47 Month 40 48 Month 41 49 Month 42 50 Month 43 51 Month 44 52 Month 45 53 Month 46 54 Month 47 55 Month 48 56 Month 49 57 Month 50 56 Month 51 59 Month 52 60 Month 53 61 Month 54 62 Month 55 63 Month 56 64 Month 57 65 Month 58 66 Month 59 67 Month 60 68 Month 61 69 Month 62 70 Month 63 71 Month 64 72 Month 65 73 Month 66 74 Month 67 75 Month 68 76 Month 69 77 Month 70 78 Month 71 Month 72 80 Month 73 81 Month 74 82 Month 75 83 Month 76 84 Month 77 85 Month 78 86 Month 79 87 Month 80 86 Month 813 Month 82 Month 83 1 Month 84 2 Month 85 3 Month 86 4 Month 87 Month 88 6 Month 89 7 Month 90 8 Month 91 9 Month 92 0 Month 93 1 Month 94 2 Month 95 13 Month 96 4 Month 97 5 Month 98 6 Month 99 17 Month 100 Month 101 9 Month 102 Month 103 1 Month 104 2 Month 105 3 Month 106 4 Month 107 5 Month 108 6 Month 109 7 Month 110 Month 111 9 Month 112 Month 113 Month 114 Month 115 13 Month 116 Month 117 5 Month 118 Month 119 27 Month 120 8 Month 121 3 Month 122 0 Month 123 Month 124 2 Month 125133 Month 126 134 Month 127 135 Month 128 136 Month 129 137 Month 130 138 Month 131 139 Month 132 140 Month 133 141 Month 134 142 Month 135 143 Month 136 144 Month 137 145 Month 138 146 Month 139 147 Month 140 148 Month 141 143 Month 142 150 Month 143 151 Month 1442. You purchase a machine. it costs $75,000 and will expand cash ow by $1,000 {month in year 1 growing by 2% per year after that. The system will work for 10 years before you have to replace it. What are the NW (at a 3.3% discount rate) and RR? The vendor offers you another machine costing $100,000 and lasting 12 years, with the same cash ow gains and a 3% growth rate. What are the NPV and the IRR for it? Should you get it'

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!

File Home Insert Page Layout Formulas Data Review View Help Tell me PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Prote H A1 -...

I am having issues with this entire problem. I posted the problems. Can you please break down the formulas and points you use please To get the dialog box, click on fx, then Financial, then FV, then...

Need help with the following excel simulation assignment: a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Please help with equations and cell references needed Check Figure: NPV $1,112 in favor of overhauling the old truck REOUIREMENTS: - Complete the requirements for P12-28 on page 603 of your textbook....

I need help understanding the formulas. I have to complete the spreadsheet below by filling in the correct formulas into the cells that are green. An image of the Excel item is at the bottom. This...

Attached is an excel spreadsheet with 4 tabs. Most of the work is done but I need help with the formulas on the blank answers and to double check what I have already completed. I have also included...

In May 2013, Rebecca Young completed her MBA and moved to Toronto for a new job in investment banking. There, she rented a spacious, two-bedroom condominium for $3,000 per month, which included...

Please Help, my team and I have different answers. Problem 6.34 Present Value Tirade Owens, a professional athlete, currently has a contract that will pay him a large amount in the first year of his...

Dodd Frank Act is considered the most comprehensive and severe financial reform act since the Great Depression, setting a new benchmark for global financial regulatory reform. The core content is to...

1. In a less than 100% stock acquisition, when valuing the NCI, do you think, the same amount of goodwill will be computed regardless whether NCI is valued at fair value or valued at its...

5. The density of aluminium is 2.7 g/cm, while the density of lead is 11.3 g/cm. Approximately how many times heavier will a block of lead be than a similar-shaped block of aluminium? (a) 2 times (b)...

A reputable polling organization in a certain country surveyed 107,300 adults, and 20% of those polled reported that they smoked. Complete parts a and b below. a) Calculate the margin of error for...