How do I solve the following exercise? I need help with the 10th, 18th and 19th part mainly.

steel manufac- APPLY e buildings $35,000 or leasing that Case Problem 1 Data File needed for this Case Problem: NP EX 9-3.xlsx Eagle Manufacturing Jim Helt is a financial manager at Eagle Manufacturing, a steel man turer specializing in construction projects ranging from support structures used in large build and highways to decorative railings for new homes and apartments. For each piece of induer equipment the company needs, Jim must evaluate whether it is better to purchase the equip or to lease the equipment for several years before replacing it with newer models. Currently i must choose between buying a large-capacity hydraulic steel metal press for $35,000 or lea machinery for three years for $500 a month. You'll use the Excel financial function to compa cost of buying versus leasing. Complete the following: 1. Open the NP_EX_9-3.xlsx workbook located in the Excel9 > Casel folder included with vo Data Files. Save the workbook as NP_EX_9_Eagle in the location specified by your instructor 2. In the Documentation worksheet, enter your name and the date. 3. In the Buy vs. Lease worksheet, in cell B4, enter $35,000 as the purchase price of the sheet metal press. 4. The sheet metal press has a salvage value of $15,000 after 120 months, or 10 years. In the B5:36, enter the salvage value and the salvage time (in months). 5. If the company does opt to buy the sheet metal press, the company will purchase a service maintenance contract that will cover maintenance costs for the next three years. In cell B9, enter $950 as the cost of this contract. 6. If the company buys the sheet metal press it will also have to pay sales tax on the purchase. In cell B10, enter 3.25% as the sales tax rate. In cell B11, enter a formula to calculate the amount of sales tax by multiplying the sales tax rate by the current price of the equipment. 7. If the company decides to buy the sheet metal press, Jim believes that it can be sold after three years for 90% of its depreciated value. In cell B12, enter 90% as the resale percentage. 8. If the company decides to lease this equipment, Eagle Manufacturing will have to pay a $2,500 security deposit and a monthly payment of $500. Enter these values in the range B15:316. 9. The table in columns D through G will be used to track the monthly cost of buying versus leasing over the next 36 months. In cell E4, enter a formula that shows the current value of the equipment entered in cell B4. 10. Calculate the value of the equipment as it depreciates each year as follows: In cell E5, calculate the difference between the value in cell E4 and the depreciation of the sheet metal press in the first month of use using the DB function. Use cells $B$4, $B$5, and $B$6 for the Cost, Salvage, and Life arguments and use cell D5 for the Period argument. b. Use AutoFill to fill the formula in cell E5 through the range E6:E40. Fill the formulas without formatting 11. In cell F4, enter as a negative cash flow the initial cost of purchasing the sheet metal press by adding the cost of the equipment in cell B4, the cost of the service contract in cell B9, and the cost of the sales tax in cell B11. 12. For Month 1 through Month 36, the company will not have to make any payments on the sheet metal press, Enter 0 as the cash flow values in the range FS:F40. 13. After Month 36, the company will sell sheet metal price at a reduced value. In cell F41, enter as a positive cash flow the final depreciated value of the equipment in cell E40 multiplied by the resale percentage in cell B12. 14. If the company chooses to lease the sheet metal press it must first pay the security deposit. In cell G4, enter as a negative cash flow the cost of the security deposit on the digital equipment entered in cell B15. 15. Every month Eagle Manufacturing must pay the leasing fee. In the range G5:G40, enter as a negative cash flow the monthly lease payment from cell B16. VA u od 16. After the term After the term of the lease is over, the company will return the sheet metal press and receive the curity deposit back. In cell G41, enter the value of the security deposit from cell B15 as a posi- tive cash flow. 18. Calculate the net 2 To assess the time value of money, Jim will assume a 5.25% discount rate. Enter this value into 1 B19. To express this as a monthly percentage, in cell B20, enter a formula to divide the value of cell B19 by 12. ulate the net present value of buying the sheet metal press. In cell B21, add the initial ment in cell F4 to the present value of owning and then reselling the equipment after three To determine the present value of owning the equipment, use the NPV function with the whily discount rate in cell B20 as the rate of return and the values in the F5:F41 as the cash flows for owning and using the equipment. te the cost leasing the sheet metal press in current dollars. In cell B22, calculate the net alue by adding the initial cost of the security deposit in cell G4 to the value returned by DV function for the discount rate in cell B20 and the cash flows in the range G5:G41. Ea mine whether buying is less expensive than leasing. In cell B23, enter an IF function that he text BUY if the net present value of buying the equipment is greater than the net sent value of leasing the equipment; otherwise display the text LEASE. 19. Calculate the cost leasing th 20. Determine whether buying displays the text BUY if the 21. Save the workbook. 22. The decision to buy versus lease is closely on to buy versus lease is closely related to the time value of money. If the discount rate is Eagle Manufacturing will be selling the sheet metal press in three years for dollars of sub- lly reduced value. Redo your analysis by changing the discount rate in cell B19 to 6.50%. workbook as NP_EX_9_Eagle2 in the location specified by your instructor, and then close it. AutoSave oft File Home - Page Layout NP_EX_9-3 - Protected View - Excel Formulas Data Review View Help Search Insert PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing X for Eagle Manufacturing D A Eagle Manufacturing Asset Value Months Initial Investment Buy Option 3 Product Information 4 Current Price 5 Salvage Value 6 Salvage Months Lease Option 8 Buy Condition 9 Service Contract 10 Sales Tax Rate 11 Tax on Sale 12 Resale Percent* 13 14 Lease Conditions 15 Security Deposit 16 Monthly Payment cova AWN- 17 18 Buy vs. Lease 19 Annual Discount Rate 20 Monthly Discount Rate 21 Buy Net Present Value 22 Lease Net Present Value 23 Choice 24 26 Resale percent represents the % of the 27 depreciated value of the asset. 29 34 Documentation Ready Type here to search OEM e AL X Eagle Manufacturing 16 Monthly Payment 18 Buy vs. Lease 19 Annual Discount Rate 20 Monthly Discount Rate 21 Buy Net Present Value 22 Lease Net Present Value 23 Choice 26 Resale percent represents the % of the 27 depreciated value of the asset. End of Contract steel manufac- APPLY e buildings $35,000 or leasing that Case Problem 1 Data File needed for this Case Problem: NP EX 9-3.xlsx Eagle Manufacturing Jim Helt is a financial manager at Eagle Manufacturing, a steel man turer specializing in construction projects ranging from support structures used in large build and highways to decorative railings for new homes and apartments. For each piece of induer equipment the company needs, Jim must evaluate whether it is better to purchase the equip or to lease the equipment for several years before replacing it with newer models. Currently i must choose between buying a large-capacity hydraulic steel metal press for $35,000 or lea machinery for three years for $500 a month. You'll use the Excel financial function to compa cost of buying versus leasing. Complete the following: 1. Open the NP_EX_9-3.xlsx workbook located in the Excel9 > Casel folder included with vo Data Files. Save the workbook as NP_EX_9_Eagle in the location specified by your instructor 2. In the Documentation worksheet, enter your name and the date. 3. In the Buy vs. Lease worksheet, in cell B4, enter $35,000 as the purchase price of the sheet metal press. 4. The sheet metal press has a salvage value of $15,000 after 120 months, or 10 years. In the B5:36, enter the salvage value and the salvage time (in months). 5. If the company does opt to buy the sheet metal press, the company will purchase a service maintenance contract that will cover maintenance costs for the next three years. In cell B9, enter $950 as the cost of this contract. 6. If the company buys the sheet metal press it will also have to pay sales tax on the purchase. In cell B10, enter 3.25% as the sales tax rate. In cell B11, enter a formula to calculate the amount of sales tax by multiplying the sales tax rate by the current price of the equipment. 7. If the company decides to buy the sheet metal press, Jim believes that it can be sold after three years for 90% of its depreciated value. In cell B12, enter 90% as the resale percentage. 8. If the company decides to lease this equipment, Eagle Manufacturing will have to pay a $2,500 security deposit and a monthly payment of $500. Enter these values in the range B15:316. 9. The table in columns D through G will be used to track the monthly cost of buying versus leasing over the next 36 months. In cell E4, enter a formula that shows the current value of the equipment entered in cell B4. 10. Calculate the value of the equipment as it depreciates each year as follows: In cell E5, calculate the difference between the value in cell E4 and the depreciation of the sheet metal press in the first month of use using the DB function. Use cells $B$4, $B$5, and $B$6 for the Cost, Salvage, and Life arguments and use cell D5 for the Period argument. b. Use AutoFill to fill the formula in cell E5 through the range E6:E40. Fill the formulas without formatting 11. In cell F4, enter as a negative cash flow the initial cost of purchasing the sheet metal press by adding the cost of the equipment in cell B4, the cost of the service contract in cell B9, and the cost of the sales tax in cell B11. 12. For Month 1 through Month 36, the company will not have to make any payments on the sheet metal press, Enter 0 as the cash flow values in the range FS:F40. 13. After Month 36, the company will sell sheet metal price at a reduced value. In cell F41, enter as a positive cash flow the final depreciated value of the equipment in cell E40 multiplied by the resale percentage in cell B12. 14. If the company chooses to lease the sheet metal press it must first pay the security deposit. In cell G4, enter as a negative cash flow the cost of the security deposit on the digital equipment entered in cell B15. 15. Every month Eagle Manufacturing must pay the leasing fee. In the range G5:G40, enter as a negative cash flow the monthly lease payment from cell B16. VA u od 16. After the term After the term of the lease is over, the company will return the sheet metal press and receive the curity deposit back. In cell G41, enter the value of the security deposit from cell B15 as a posi- tive cash flow. 18. Calculate the net 2 To assess the time value of money, Jim will assume a 5.25% discount rate. Enter this value into 1 B19. To express this as a monthly percentage, in cell B20, enter a formula to divide the value of cell B19 by 12. ulate the net present value of buying the sheet metal press. In cell B21, add the initial ment in cell F4 to the present value of owning and then reselling the equipment after three To determine the present value of owning the equipment, use the NPV function with the whily discount rate in cell B20 as the rate of return and the values in the F5:F41 as the cash flows for owning and using the equipment. te the cost leasing the sheet metal press in current dollars. In cell B22, calculate the net alue by adding the initial cost of the security deposit in cell G4 to the value returned by DV function for the discount rate in cell B20 and the cash flows in the range G5:G41. Ea mine whether buying is less expensive than leasing. In cell B23, enter an IF function that he text BUY if the net present value of buying the equipment is greater than the net sent value of leasing the equipment; otherwise display the text LEASE. 19. Calculate the cost leasing th 20. Determine whether buying displays the text BUY if the 21. Save the workbook. 22. The decision to buy versus lease is closely on to buy versus lease is closely related to the time value of money. If the discount rate is Eagle Manufacturing will be selling the sheet metal press in three years for dollars of sub- lly reduced value. Redo your analysis by changing the discount rate in cell B19 to 6.50%. workbook as NP_EX_9_Eagle2 in the location specified by your instructor, and then close it. AutoSave oft File Home - Page Layout NP_EX_9-3 - Protected View - Excel Formulas Data Review View Help Search Insert PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing X for Eagle Manufacturing D A Eagle Manufacturing Asset Value Months Initial Investment Buy Option 3 Product Information 4 Current Price 5 Salvage Value 6 Salvage Months Lease Option 8 Buy Condition 9 Service Contract 10 Sales Tax Rate 11 Tax on Sale 12 Resale Percent* 13 14 Lease Conditions 15 Security Deposit 16 Monthly Payment cova AWN- 17 18 Buy vs. Lease 19 Annual Discount Rate 20 Monthly Discount Rate 21 Buy Net Present Value 22 Lease Net Present Value 23 Choice 24 26 Resale percent represents the % of the 27 depreciated value of the asset. 29 34 Documentation Ready Type here to search OEM e AL X Eagle Manufacturing 16 Monthly Payment 18 Buy vs. Lease 19 Annual Discount Rate 20 Monthly Discount Rate 21 Buy Net Present Value 22 Lease Net Present Value 23 Choice 26 Resale percent represents the % of the 27 depreciated value of the asset. End of Contract