Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill out the excel sheet, and how would I know why the farmer should or should not invest in the facility? Should a farmer invest
Fill out the excel sheet, and how would I know why the farmer should or should not invest in the facility?
Should a farmer invest in and operate a 55.000 hu grain drying and storage facility? The cost of the facility is $90,000. The economic life is ten years. The salvage value is expected to be $14,000. In a partial budgeting framework, one must compare the added cost of operating the facility each year relative to the savings of eliminating the elevator charges each year. The elevator charge for drying and storage has averaged $0.50 per bushel the past few years, so the first year savings is expected to be $27,500. The farmer expects that the total elevator charge will go up about $50/yr. (Note: look at this like a savings because of the invest you are making you won't have to pay this fee) The operating costs of the new facility are expected to be $0.25/bu., repairs, insurance and taxes are expected to be an additional $700.00 a year. As you new facility gets older the repair costs are expected to increase $100 yearly as can be seen in the cost numbers below. . Also note for the NPV calculations; the real interest rate is assumed to be 3.0%, inflation is expected to be 2.0% annually, and the risk factor is expected to be 2.0%. Savings Costs Purchase Price Year 1 $27,500 $14,450 and Sakage for Terminal Revenue NetCash Flow Discount Present Value Year Vaues or Savings Costs R-C-PC or-SV) Rate Factor Year 2 $27,550 $14,550 Purchase Price of 0.00 0.0% 1.000 Year 3 $27,600 $14,650 0.00 0.0% 1.0000 0.00 0.0% 1.0000 Year 4 $27,650 $14,750 0.00 0.0% 1.0000 Year 5 $27,700 $14,850 0.00 0.0% 1.0000 0.00 0.0% 1.0000 Year 6 $27,750 $14,950 0.00 0.0% 1.0000 Year 7 $27,800 $15,050 0.00 0.0% 1.0000 0.00 0.0% 1.000 Year 8 $27,850 $15,150 0.00 0.0% 1.000 Year 9 $27,900 $15,250 Salege Price 10 0.00 0.0% 1.000 Year 10 $27,950 $15,350 Total 0.00 0.00 0.00 NPV = Present Vaue 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00% Real Interest Rate Inflation Risk Factor 0.00% 0.00%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started