Question: Problem #3- This problem is worth 15 points. You must use an Excel spreadsheet for your answer. Axion Corporation Balance Sheet December 31, 202X Assets


Problem #3- This problem is worth 15 points. You must use an Excel spreadsheet for your answer. Axion Corporation Balance Sheet December 31, 202X Assets Cash Accounts receivable Land, building & equipment Prepaid expenses Patent Inventory $ 32,500 174,175 540,000 14,000 17,000 50,000 Total Assets $ 827,675 Liabilities and Owners' Equity Accounts payable Mortgage payable Taxes payable Unearned revenue Common stock Retained earnings $ 54,300 150,000 40,000 11,000 50,000 522,375 Total Liabilities and Owners' Equity $ 827,675 The books have been closed for the year. Any changes in revenues or expenses will be adjusted to Retained Earnings. Required: Based on the information above, and the information below, prepare IN GOOD FORM: 5) $5,000 of the mortgage payable is due within the next 12 months. 6) $11,000 was recorded an unearned revenue when it was received in advance for a customer's order back in September. The goods were shipped on October 15th of the current year. Problem #3- This problem is worth 15 points. You must use an Excel spreadsheet for your answer. Axion Corporation Balance Sheet December 31, 202X Assets Cash Accounts receivable Land, building & equipment Prepaid expenses Patent Inventory $ 32,500 174,175 540,000 14,000 17,000 50,000 Total Assets $ 827,675 Liabilities and Owners' Equity Accounts payable Mortgage payable Taxes payable Unearned revenue Common stock Retained earnings $ 54,300 150,000 40,000 11,000 50,000 522,375 Total Liabilities and Owners' Equity $ 827,675 The books have been closed for the year. Any changes in revenues or expenses will be adjusted to Retained Earnings. Required: Based on the information above, and the information below, prepare IN GOOD FORM: 5) $5,000 of the mortgage payable is due within the next 12 months. 6) $11,000 was recorded an unearned revenue when it was received in advance for a customer's order back in September. The goods were shipped on October 15th of the current year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
