please provide detailed analysis to question b based on the spreadsheet

Foxridge Investment Group Acquisition Data Land Value Buildings/Improvements Purchase Price $30,000 $140,000 $170,000 Financing Data Down Payment Amount Financed APR Term Annual Payment $40,000 $130,000 11.00% 20 $16,325 Economic Assumptions Rental Income Year One $35,000 Rental Income Growth Rate Min Max 2.00% 6.00% V&C Allowance Min Max 1.00% 5.00% Operating Expenses Mean StDev 45.00% 2.00% Min Max 40.00% 50.00% Tax Rate 28.00% Property Value Groth Rate Min Max 1.00% 5% Sales Commission 5.00% Discount Rate 12.00% Cash Flows In Year Gross Income Less: V&C Allowance Operating Expenses Net Operating Income Less: Depreciation Interest Taxable Income Taxes Paid Principal Paid Net Cash Flow 1 $35,000 $1,538.08 15749.99 $17,711.93 2 $36,432 $1,461.27 7377.38 $27,592.86 $5,090.91 14300 ($1,678.98) $5,090.91 14077.27 $8,424.68 ($470.11) $2,358.91 3 $35,765 $764.52 3259.03 $31,740.95 4 $35,765 $733.49 1466.58 $33,564.43 Financial Summary 5 $35,765 $1,718.45 659.97 $33,386.10 $5,090.91 13830.04 $12,820.00 $5,090.91 13555.61 $14,917.91 $5,090.91 13250.99 $15,044.19 $3,589.60 $4,177.02 Confidence Intervals Sales Price @ year 5 Less: Selling Expense Tax Bias Taxable Gain $190,066.12 Proceeds From Sale Less: $180,562.81 $9,503.31 $144,545.45 $36,017.36 $4,212.37 $2,025 $2,248 $2,495 $2,769 $3,074 $1,857.05 $8,908.95 $11,826.35 $13,062.42 $12,848.72 Taxes Loan Payof Net Cash From Sales $10,084.86 $117,389 $53,089.04 PV of sale proceeds PV of cash flows Less: Original Equity Total NPV $30,124.15 $32,770.11 $40,000 $22,894.26 Probability Positive NPV 1 Sample Mean Sample Standard Deviation Sample Size Confidence Level 95% LCL for the population mean 95% UCL for the population mean 20,901 6,408 5000 95% 20,724 21,079 Cash Flows In Year Gross Income Less: V&C Allowance Operating Expenses Net Operating Income Less: Depreciation Interest Taxable Income Taxes Paid Principal Paid Net Cash Flow 1 $35,000 $1,050.00 15750.00 $18,200.00 2 $35,700 $1,071.00 7229.25 $27,399.75 $5,090.91 14300 ($1,190.91) $5,090.91 14077.27 $8,231.57 ($470.11) $2,358.91 3 $34,629 $1,038.87 3155.57 $30,434.56 4 $34,629 $1,038.87 1420.01 $32,170.12 Financial Summary 5 $34,629 $1,038.87 639.00 $32,951.13 $5,090.91 13830.04 $11,513.62 $5,090.91 13555.61 $13,523.61 $5,090.91 13250.99 $14,609.22 $3,589.60 $4,177.02 Confidence Intervals Sales Price @ year 5 Less: Selling Expense Tax Bias Taxable Gain $187,693.74 Proceeds From Sale Less: $178,190.43 $9,503.31 $144,545.45 $33,644.98 $4,212.37 $2,025 $2,248 $2,495 $2,769 $3,074 $2,345.11 $8,715.84 $10,519.96 $11,668.11 $12,413.75 Taxes Loan Payof Net Cash From Sales $10,084.86 $117,389 $50,716.66 PV of sale proceeds PV of cash flows Less: Original Equity Total NPV $27,572.79 $30,873.80 $40,000 $18,446.59 Probability Positive NPV 1 Sample Mean Sample Standard Deviation Sample Size Confidence Level 95% LCL for the population mean 95% UCL for the population mean 16,605 5,876 5000 95% 16,768 16,443