Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedFill 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Auditing E4 Im

Authors: KNAPP

4th Edition

0324048602, 978-0324048605

More Books

Students also viewed these Accounting questions