Description:

This spreadsheet is designed to help users evaluate the value of different investments. It includes sections for setting up investment parameters, projecting financial outcomes, and conducting discounted cash flow (DCF) analysis. Key components include:

• Setup: Initial configuration of the spreadsheet for various investments, including defining investment types and periods.
• Investment Valuation Summary: A detailed overview of investment names, types, amounts, periods, and expected ROI.
• Financial Projection: A projection of revenues, expenses, and net income over the investment period.
• Discounted Cash Flow (DCF) Analysis: Calculation of present value and net present value (NPV) using discount rates.
• Sensitivity Analysis: Analysis of how changes in key variables such as revenue and expenses impact the investment’s value.