The bottom picture is a template the link to it is below! Thank you!

All of the following questions relate to a new hog investment. Questions 1 and 2 consider the investment with and without financing. Question 3 looks at sensitivity analysis and question 4 asks for your evaluation. Question 5 adds in the effects of expectations on growth of revenue and costs. Note; the example in the book uses depreciation rates different from IRS tables. Use the MACRS 150% depreciation rates from the other file. (Pg 85 in 6th edition, pg 29 in seventh) 1. A new hog investment requires an initial outlay of $100,000. There will be 236 sows. The returns per sow each year are $650 and the operating costs are $575 per sow. There is no salvage value (terminal value is $0), a tax rate of 30 percent, and a 10% discount rate. The $100,000 initial investment includes a building and equipment costing $90,000 (7 year life) and livestock costing $10,000 (3 year life). (note: depreciation table is on page 85 of your text). Find the NPV, IRR, MIRR and payback for this investment assuming that nothing is financed. Assume that all cash flows occur at the end of the year. Note: this one assumes that there are 0% growth on both receipts and expenses. It also assumes no financing. Later questions will add that in. Since there is no financing it should not matter what the finance rate is. You can put in 8% which will be used in the next question. 2. Now use the above information but assume that 80% is financed on a 10 year loan with equal payments at an interest rate of 8%. Find NPV, IRR, MIRR, and payback for this investment.

3. Conduct a sensitivity analysis of the NPV using different discount rates of 6%, 8%, 10%, 12%, and 14%. Give me the NPVs for each the scenario in part 1 and part 2. If you have the spreadsheet set up in excel you should just be able to change the discount rate and write down the NPV. 4. Tell me whether you would undertake the investment or not. With either decision tell me why you chose what you did, what decision criteria you used (e.g. NPV, IRR, etc) and why you used them. Also tell me if there is any other information that you would want to know before making the decision. 5. Now redo both scenarios assuming that the returns and operating expenses are expected to grow at 2%. Give me the IRR, MIRR, NPV, and payback.

Depreciation Sch. homework 10 (1) - Excel Jessica Sharp X Share File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Insert MSFT $ 47.24 Calibri 11 - A A al Wrap Text General AY O 0.26% X Delete Sort & Find & Launch Paste Merge & Center $ ~ % " 6.0 .OC Conditional Format as Cell .00 3.0 Formatting Table Styles Format Filter ~ Select Stock Connector Clipboard Font Alignment Number Styles Cells Editing E8 X 8.74 K M N O P Q R S T U V W X A B C D E F G H Annual Depreciation Rates Under MACRS (Percentage rates) 3 year 5 year 7 year 10 year 15 Year 20 Year 25 15 10.71 7.5 5 3.75 37.5 25.5 19.13 13.88 9.5 7.22 25 17.85 15.03 11.79 8.55 6.68 12 16.66 12.25 10.02 7.7 6.18 16.66 12.25 8.74 6.93 5.71 6 8.33 12.25 8.74 6.23 5.28 Co 7 12.25 8.74 5.9 4.89 10 co 6.13 8.74 5.9 4.52 8.74 5.9 4.46 10 8.74 5.9 4.46 11 4.37 5.9 4.46 12 5.9 4.46 5.9 4.46 5.9 4.46 5.9 4.46 2.95 4.46 4.46 20 18 4.46 21 19 4.46 22 20 4.46 23 21 2.23 24 25 26 27 Sheet1 Sheet2 |Sheet3 + - - + 79% Ready EO 3:10 PM Type here to search W X 100% 11/1/2021Module 10 Template (1) [Protected View] - Excel Jessica Sharp X File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share G30 X v fx A B C D E F G H J K L M N O P Q R S T U Chapter 10 hog examples Formulas used Pmt(rate, periods, PV) Numbers to Input Units per year ppmt(rate, period,nper,pv,fv) 4 Analysis Numbers $/unit - return ipmt(rate, period,nper,pv, fv) $/unit - cost IRR(range of cash flows) 6 Initial Payment NPV(rate, range of cash flows) Terminal MIRR(range of cash flows, finance rate, reinvestrate) 8 Growth Net present value Depreciable Assets 9 receipts IRR Buildings 7 year 10 Expenses MIRR Equipment 7 year 11 Tax rate payback Livestock 3 year 12 % financed Depreciation schedule 13 Finance rate 2 5 8 14 Discount rate 0.333333 0.444444 0.1481481 0.0740741 15 Yrs financed 0.142857 0.244898 0.1749271 0.1249479 0.089249 0.089249 0.08925 0.04462 16 17 18 Year > > 0 1 2 3 5 6 7 8 9 10 19 20 Receipts 21 Terminal value 22 Cash inflow 23 24 Down 25 Operating expenses 26 Depreciation 27 Interest 28 Principal 29 Taxable income 30 Income taxes 31 Cash outflow 32 Net cash flow 33 34 cumm of 35 ch 10 example + Ready EO + 70% 3:14 PM Type here to search W X 100% 11/1/2021