1. Cincinatti Milicron is an important manufacturer of tools. You choose to purchase one of their Low Pressure Injection Moulding machines to increase your production facilities. It costs 1500000 cu. Transportation from the US adds a further 30000 cu, and installation costs amount to 50000 cu. These additional costs will be financed as part of the purchase costs. You will use a business loan at 7%, charged over 10 years.

How much is each monthly payment?

2. From the above question, how much capital will be repaid in month 92?

What excel formula would you use for the 2nd question and how would it be filled.