So I have this problem due tonight and I just cannot figure it out at all. I am going to provide the data and am looking for the equation I would enter into the chart. (EXCEL 2007)
Here are the problems we have to do.
1. (10 points) Define names for the cells C2:C9 and the cell C21. Fill in the cells of the range C12:G19 with formulas. You should, where possible/desirable, use the defined name(s) in your formulas. If not, you will not be able to create scenarios later.
2. (3 points) Insert a formula into the cell C21. Again, use defined name(s) where possible. In finance and accounting, the net present value (NPV) of a series of cash flows, both incoming and outgoing, is defined as the sum of the discounted present values of the individual cash flows.
3. (7 points) Create three scenarios for NPV of OPAT using the Scenario Manager: Original, Best, and Worst. You should figure out five changing cells. Note: Original scenario must use the original values of the changing cells. Once you are done with the scenarios, create a Scenario Summary.
<tbody>
</tbody>
^^^Data
I need to know how to plug that information into this chart.
<tbody>
</tbody>
Here are the problems we have to do.
1. (10 points) Define names for the cells C2:C9 and the cell C21. Fill in the cells of the range C12:G19 with formulas. You should, where possible/desirable, use the defined name(s) in your formulas. If not, you will not be able to create scenarios later.
2. (3 points) Insert a formula into the cell C21. Again, use defined name(s) where possible. In finance and accounting, the net present value (NPV) of a series of cash flows, both incoming and outgoing, is defined as the sum of the discounted present values of the individual cash flows.
3. (7 points) Create three scenarios for NPV of OPAT using the Scenario Manager: Original, Best, and Worst. You should figure out five changing cells. Note: Original scenario must use the original values of the changing cells. Once you are done with the scenarios, create a Scenario Summary.
| Tax Rate | 40% |
| Units Sold in Year 1 | 12000 |
| Annual Sales Growth Rate | 5% |
| Unit Price in Year 1 | $7.50 |
| Unit Cost in Year 1 | $6.00 |
| Annual Interst Rate | 15% |
| Annual Unit Cost Growth Rate | 5% |
| Annual Unit Price Growth Rate | 3% |
<tbody>
</tbody>
^^^Data
I need to know how to plug that information into this chart.
| Year | 1 | 2 | 3 | 4 | 5 |
| Units Sold | |||||
| Unit Price | |||||
| Unit Cost | |||||
| Total Revenue | |||||
| Total Cost | |||||
| Operation Profit Before Tax | |||||
| Tax Amount | |||||
| Operation Profit After Tax (OPAT) Any help for any of this would be greatly appreciated as I cannot figure out even where to start. |
<tbody>
</tbody>
