Please solve in EXCEL. show all formulas/work. Will upvote! Thank you in advance!!

1- Your company is evaluating a new project that will require the purchase of an asset for $32,000 installed. The asset will be depreciated using 3-year MACRS.

The asset will be operated for 3 years and is expected to have a market value of $6,000 at the end of 3 years. Assuming the tax rate is 30%.

Using the tax rates from the provided table, what is the after-tax salvage value for the asset after 3 years?

Year	3-year	5-year	7-year
1	0.333	0.2	0.143
2	0.445	0.32	0.245
3	0.148	0.192	0.175
4	0.074	0.115	0.125
5		0.115	0.089
6		0.058	0.089
7			0.089
8			0.045
9
10
11

2-

Your company is evaluating a project that will require the purchase of an asset with a price of $16,000 the shipping will cost an additional $1,500 and installation will be $850. The new project will require an increase in inventory of $300, an increase in A/R of $200 and an increase in A/P of $100 in the initial period.

Assuming tax rate of 30%, what is the initial outlay, in year 0, for this project?

		17,250
		17,900
		18,950
		18,350
		18,750