Using Microsoft Excel follow the approach on MT-S to compound interest monthly for the following scenario. When borrowing money from X corp to purchase machining equipment, balances (which include prior interest) are charged 2% If $20,000 were borrowed how much would be owed at the end of 6 month? End of 9 months? End of 12 months? If a $100 payment were applied at each month (after interest/total owed) was calculated, how would it charge the balance at 6, 9, and 12 months? An investor wants to buy land that will be worth $40,000 in 15 years. If the value of land increases at 7% each year, How much is the land worth today? A person borrow $1200 today and plans on paying it off in 2 years, At 5% interest (Using F/P equation) how much is the debt worth? Based on the cash flows below, draw a cash-flow diagram