For the next eight

$($

$8$

$)$

$$questions$,$ you will need the supplemental Excel file found HERE.

Complete the Income Statement projection in the supplemental Excel file. Assume that for CY

$2$

$0$

$2$

$4$

P

$,$

$$all assumptions

$($

i

$.$

e

$.$

$$revenue growth, operating margin, D&A as a

$\%$

$$of revenue, the tax rate, networking capital as a

$\%$

$$of revenue, and capital expenditures as a

$\%$

$$of revenue

$)$

$$are equal to the average of the previous two

$($

$2$

$)$

$$years and remain constant throughout the projection period.

NOTE: You are working only in the yellow shaded cells. The Excel file is already formatted for you. To avoid calculation errors, do not change the formatting in the file. Question $8$ of $8$: Based on the updated Income Statement projection, what is CY $2029$P Net Income, rounded to the nearest dollar?

$$499$

$$429$

$$305$

$$267$