NEED ASAP PLEASE AND THANK YOU!! PROBLEM STARTS ON LAST TWO PAGES!!

MixMax Company Comparative Balance Sheet July 1, and July 31, 20X1 7-1-X1 7-31-X1 Difference Assets Cash Accounts Receivable Allowance for Doubtful Accounts Inventory Property, Plant and Equipment Accumulated Depreciation $ 44,000 63,000 (5,600) 14,000 27,000 (2,430) $ 41,000 67,000 (7,280) 28,000 27,000 (2,835) Total Assets $ 139,970 $ 152.885 $ 14,500 7,760 422 Liabilities & Stockholders' Equity Accounts Payable - Merchandise Accounts Payable - Services Interest Payable Taxes Payable Current Portion of Debt Deferred taxes Long-term Debt Common Stock Retained Earnings 3,563 198 38,627 13,000 61,900 $ 19,000 4,260 416 4,802 ? 396 38,627 13,000 ? Total Liabilities and Stockholders' Equity $ 139,970 $ ? The MixMax Company Income Statement For Month Ended July 31, 20X1 $ 72,000 42,000 30,000 $ Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Operating Expenses Bad Debt Expense Total Operating Expenses Operating Income Nonoperating Items: Interest Expense Income before Income Tax Expense Income Tax Expense 14,204 2,880 17,084 12,916 416 12,500 ? Net Income $ ? Statement of Cash Flows For Month Ended July 31, 20X1 Cash (Outflows) from Operating Events $ (?) Cash (Outflows) from Financing Events Repayment of loan Total Financing Events $ (579) (579) (Decrease) in Cash $ (?) July Additional Assignment: Recall the $45,000 loan that The MixMax Company arranged to finance the purchase of its equipment back on January 1, 20X1. The terms of the loan required monthly payments of $1,001, the first one to be made on February 1, 20x1, and the last on January 1, 20x6 (5 years), at a 12 percent annual interest rate, compounded monthly. Part A: Using Excel, set-up and complete the following schedule. Numbers should be entered in the input area for N, 1, and PV. Use Excel to calculate the payment. Every cell in the loan amortization schedule should contain a formula except for the Period column. Option A N 1 PV PMT Interest Period Payment Expense Principal Note Payable 45,000 NO 1 2 3 1,001 1,001 1,001 59 60 1,001 1,001 0 o TOTALS 15,060 45,000 Part B, C, & D: Alternatively, the company could have borrowed the same $45,000, at the same 12 percent annual interest rate (compounded monthly), for the same number of 60 periods, by making one of the following monthly payments: B. $726 C. 450 D. 174 Copy your Excel sheet to create 3 additional sheets and rename each Option B, Option C, and Option D. Change the payments in each sheet accordingly (to $726, 450, and 174). What difference did these payment options have on Total Interest Expense, Total Principal Payments, and the Balance of the Note Payable? Write your conclusions at the bottom of each sheet for Option B, Option C, and Option D