Assume that you are the finance officer for a company that sells farm machinery. The owner has asked you to determine the list price the company should charge for a particular piece of machinery under several different financing packages available to your customers. Assume that you need to bring in $150,000 on a single machine for the company to break even and that market interest rates are 3%, 4% and 5% AR, respectively, for 2-, 4-, and 6-year loans. Determine the common list price and rebates that will bring in $150,000 for the following monthly financing options:

1- No payments or interest for 4 months, followed by 2 years of financing at 2% AR. (solve in Excel)

2- Financing at 3% AR for 4 years. (Solve in Excel)

3- No payments for 1 year, followed by 6 years of financing at 1% annual interest. (solve in Excel)