Final answer:
To create an excel spreadsheet with all the data on one page, follow these steps: set the page format to landscape, create sections for initial investment, depreciation, and financial metrics.
Step-by-step explanation:
To create an excel spreadsheet with all the data on one page, you can follow these steps:
- Set the page format to landscape.
- Create a section showing the initial investment.
- Create a section showing the depreciation percent for both assets each year, along with the book value of the asset after depreciation.
- Create a section showing the net present value (NPV), internal rate of return (IRR), and payback period.
To ensure clarity and accuracy, you can use formulas and functions in Excel for calculations and formatting tools to organize the data effectively.