You have the following historical year information:

New Purchases: $300.00

Sales of Old Equipment: $12.00

Gross Fixed Assets, ending: $4,000.00

You also know the following assumptions:

Growth in new purchases will be 5% in the first year, and 10% in all subsequent years

Sales of equipment % new purchases will be constrained to 3%/per year indefinitely.

Produce an excel sheet that shows:

1. 5-year projection of all (3) data points.

(show formuls please)

You have the following historical year information: New Purchases: $300.00 Sales of Old Equipment: $12.00 Gross Fixed Assets, ending: $4,000.00 You also know the following assumptions: Growth in new purchases will be 5% in the first year, and 10% in all subsequent years Sales of equipment \% new purchases will be constrained to 3%/ per year indefinitely. Produce an excel sheet that shows: 1. 5-year projection of all (3) data points. (show formuls please)