create npv analysis
User Generated
znpnebba_wrff
Business Finance
Description
Suppose you are consultant for a farmer who owns 100 acres of usable land. She wants to plant some combination of corn and wheat on the land. She wants you to build a spreadsheet that will calculate NPV and IRR based on her estimates for costs and revenues related to this project.
Create an NPV analysis template that the farmer can use to make the optimal investment decision. Use the following template.
"Assumptions" Tab
- Insert placeholder data of your choosing into yellow input cells
- Create dynamic calculations for all non-input cells
"Worksheet" tab
- Create dynamic calculations using data from assumptions tab
"ROI" Tab
- Create dynamic cash flow calculations for each year using data from the other tabs
- Use excel formulas to calculate NPV and IRR based on the net cash flow data
- Use conditional formatting to indicate when the NPV and IRR indicate a good investment
"Scenarios" Tab
- Answer the questions relating to each scenario using your completed spreadsheet as the calculator
Seek help from classmates and/or TAs as necessary. Upload your completed file to Canvas prior to the due date
This question has not been answered.
Create a free account to get help with this and any other question!
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Twelve Years A Slave
by Solomon Northrup
Dune
by Frank Herbert
How to Win Friends and Influence People
by Dale Carnegie
Cat on a Hot Tin Roof
by Tennessee Williams
The Lost Man
by Jane Harper
The Goldfinch
by Donna Tartt
Rules Of Civility
by Amor Towles
Breakfast at Tiffanys
by Truman Capote
Good Kids Bad City
by Kyle Swenson