Cash $ 25,000 $ 45,000 Accounts Receivable, Net 55,000 16,000 Inventory 110,000 25,000 Equipment, Net 550,000 160,000 Other Assets 140,000 46,000 Total Assets $880,000 $292,000 Current Liabilities $120,000 $ 15,000 Note Payable (long-term) 190,000 55,000 Common Stock (par $20) 480,000 210,000 Additional Paid-In Capital 50,000 4,000 Retained Earnings 40.000 8,000 Total Liabilities and Stockholders' Equity $880,000 $292.000 Sales Revenue $800,000 $280,000 Cost of Goods Sold 480,000 150,000 Other Expenses 240,000 95,000 Net Income $ 80,000 $ 35,000 Other Data Per share price at end of year $ 14.00 $ 11.00 Selected Data from Previous Year Accounts Receivable, Net $ 47,000 $ 14,000 Note Payable (long-term) 190.000 55,000 Equipment, Net 550.000 160,000 Inventory 95,000 38,000 Total Stockholders' Eamit 570.000 202.000 These two companies are in the same business and state but different cities. Each 2 company has been in operation for about 10 years. Both companies received an unqualified audit opinion (clean) on the financial statements. Both companies estimate bad debts based on aging analysis, but company [B] has estimated slightly higher uncollectible rates than (A). Neither company issued stock in the current year. Assume the end-of-year total assets and net equipment balances approximate the year's average and all sales are on account. Company (A] wants to borrow $75,000 cash and [B] is asking for $30,000. The loans will be for a two- year period. B. Based on the ratios, perform an analysis to determine which loan is preferable to the bank. Consider in your analysis the profitability, liquidity, and solvency ratios. (20 points) The results of the calculations in part A and the analysis in part B are to be summarized in a memorandum format, addressed to the branch manager. Please use a word document file and a 12 font (single spaced, Times New Roman). You may choose to include tables or other visuals as per your preference. The document should be formatted professionally and free of typos and glaring grammar issues. (20 points)