Let's prepare a profit and loss ... your spreadsheet. Month-by-month numbers should be prepared for the first two years. You can then apply some formulas to your annual figures for year two to produce ...

The ABS function is a simple yet powerful tool in Microsoft Excel for handling data analysis tasks where the direction of the values is irrelevant, and only the magnitude matters. Understand the ABS ...