164k views
3 votes
Create an excel spreadsheet with all the data contained on one page (use landscape as your page format). include in your spreadsheet a section showing the initial investment, a section showing the depreciation percent for both assets each year (along with the book value of the asset after depreciation), and a section showing the npv, irr, and payback.

User WIlfinity
by
6.9k points

1 Answer

0 votes

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:

  1. Set the page format to landscape.
  2. Create a section showing the initial investment.
  3. Create a section showing the depreciation percent for both assets each year, along with the book value of the asset after depreciation.
  4. 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.

User Dlinet
by
6.8k points