I will only rate / accept if the answer is in excel in a working document!!!!!!

You have secured a loan from PNC Bank for two years to build a new business location. The terms of the loan are that you will borrow $125,000 now and an additional $25,000 in one year. Interest of 10 percent APR will be charged on the balance monthly. Since no payments will be made during the 2-year loan, the balance will grow at the 10 percent compounded rate. At the end of the two years, the balance will be converted to a traditional 30-year mortgage at a 6 percent interest rate. What will you be paying as monthly mortgage payments (principal and interest only) You also secured a loan from Bank of America for two years to build. The terms of the loan are that you will borrow $100,000 now and an additional $50,000 in one year. Interest of 8 percent APR will be charged on the balance monthly. Since no payments will be made during the 2-year loan, the balance will grow. At the end of the two years, the balance will be converted to a traditional 15-year mortgage at a 8 percent interest rate. What will you pay as monthly mortgage payments (principal and interest only)?

2. Create a spreadsheet with the amortization and payment schedule. Include, Beginning balance, monthly payment, monthly payment towards interest and amount towards principal, total interest paid, and ending balance for both loans.