In: Finance
Create a new workbook in Excel. Please include an input area and an answer area for each problem. You will have an answer for each bullet point. Formatting is up to you. Just make sure it is easy to tell where your answers are, and what equation you used in excel to get the answer.
Case A. Calculation of present value of the salvage value for SDI per acre :
Case B : Total net investment per acre of SDI after netting off of the present value of salvage value
= $1200-$146.47
=$1053.53
Case C : Calculation of present value of the salvage value for LEPA per acre :
Case D : Total net investment per acre of LEPA after netting off of the present value of salvage value
=$556-$67.86
=$488.14