Create input cell for required return

Assignment Help Financial Management

Reference no: EM131896752

Suppose you are consultant for a farmer who owns 100 acres of usable land. She is going 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 best guesses about the costs and revenues related to this project.

Create an NPV analysis template with the following characteristics: "ROI" Tab

•Create input cell for required return

•Label year columns from zero to ten

•Label cash flow rows as follows ?Capital investment ?Expenses ?Revenue ?Net cash flow

•Create dynamic calculations for each year/cash flow type combination using data from Assumptions tab

•Use excel formulas to calculate NPV and IRR based on the net cash flows

•Use conditional formatting to indicate when the NPV and IRR indicate a good investment "Assumptions" Tab

•Create input cells for the following

?Acres - corn

?Acres - wheat

?Capital investment - corn

?Capital investment - wheat

?Year 1 corn expense/acre

?Corn expense annual increase (%)

?Year 1 wheat expense/acre

?Wheat expense annual increase (%)

?Year 1 corn revenue/acre

?Corn revenue annual increase (%)

?Year 1 wheat revenue/acre

?Wheat revenue annual increase (%)

Reference no: EM131896752

Questions Cloud

Price of put option with the same exercise price : What is the price of a put option with the same exercise price?

The annual continuously compounded rate of interest : If the stock is currently priced at $68.40, what is the annual continuously compounded rate of interest?

The new drug will generate for delta pharmaceuticals : What’s the market’s consensus of the NPV (in millions) that the new drug will generate for Delta Pharmaceuticals?

Market value before and after the stock dividend : Show your ownership, market value before and after the stock dividend.

Create input cell for required return : Suppose you are consultant for a farmer who owns 100 acres of usable land. Create input cell for required return. Label year columns from zero to ten.

Optimize this portfolio using markowitz portfolio selection : How many estimates of expected returns, variances and covariances are needed to optimize this portfolio using Markowitz portfolio selection?

What must the coupon rate be on bonds : The bonds make semiannual payments. What must the coupon rate be on these bonds?

What is sunk cost and opportunity cost : What is a sunk cost and an opportunity cost? What role does forecasting play in the decision making process?

What is the invoice price of bond : Suppose that you purchase a bond with a quoted price of $1,011.76 on January 15. What is the invoice price of the bond?

User Account

All Pages