Financial Forecast

Develop a spreadsheet for a financial forecast that isolates the assumptions and initial values; to use conditional formatting, styles, indentation, and rotate text to format the spreadsheet. Start year is $2024,$ end year is the first year when after tax earnings becomes zero or negative. Please look at tax rate mentioned in start Excel sheet. Create a bar chart and trend chart like in Assignment $1($previous assignment$)$ for after tax earnings.

Important:

$0\mathrm{.}3$ FOR FIRST $5$ YEARS, $0\mathrm{.}25$ FOR NEXT $5$ YEARS, AND $0\mathrm{.}4$ AFTER THAT. IF EARNINGS BEFORE TAX

Tax Rate IS ZERO OR NEGEATIVE, THE TAX RATE IS ZERO

End Year of

Year when first Earnings after tax becomes

Forecast negative OR ZERO