This is my second day, and 5th attempt at trying to answer this question and I am so lost. If someone could provide the answers that show the formulas in each of the cells of Excel, that would really help me figure out what I am doing wrong here! Thank you in advance!

model. The old machine has a book value of $700,000 and a remaining useful life of 5 years. The current machine would be worn out and worthless in 5 years, but DeYoung can sell it now to a Halloween mask manufacturer for $260,000. The old machine is being depreciated by $140,000 per year for each year of its remaining life. The new machine has a purchase price of $1,175,000, an estimated useful life and MACRS class life of 5 years, and an estimated salue The applicable depreciation rates are 20.00%,32.00%,19.20%,11.52%,11.52%, and 5.76%. Being highly efficient, it is expected to economize on electri power usage, labor, and repair costs, and, most importantly, to reduce the number of defective chickens. In total, an annual saving $245,000 will be realized if the new machine is installed. The company's marginal tax rate is 35% and the project cost of 13%. a. What is the initial net cash flow if the new machine is purchased and the old one is replaced? Round your answer to the nearest $ Do not round intermediate calculations. Round your answers to the nearest dollar. d. Should the firm purchase the new machine? Support your answer. Do not round intermediate calculations. Round your answer to the nearest dollar. NPV: \$