Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please review the balance sheet I created (below) and confirm that the total debt to total equity ratio is calculated correctly? Balance Sheet
Can you please review the balance sheet I created (below) and confirm that the total debt to total equity ratio is calculated correctly?
Balance Sheet Year 1 Statement as of Dec. 31 Year 2 Year 3 Year 4 14,154,373 Assets Cash Land Building Accumulated Depreciation: Building Building Improvements Accumulated Depreciation: Building Improvements Construction Equipment Accumulated Depreciation: Construction Equipment Appliances Accumulated Depreciation: Appliances Prepaid Insurance Total Assets 624,520 2,900,000 16,400,000 (596,364) 2,741,894 (99,705) 35,000 (5,000) 100,770 (20,154) 1,179,096 2,900,000 16,400,000 (1,192,727) 2,741,894 (199,410) 1,754,095 2,900,000 16,400,000 (1,789,091) 2,741,894 (299,116) 100,770 (40,308) 100,770 (60,462) 22,080,961 21,889, 314 21,748,091 14,154,373 Liabilities Accounts Payable Senior Loan Payable Construction Loan Payable Administrative Payable Water Payable Utilities Payable Property Management Payable Repair and Maintenance Payable Payroll Payable Marketing Payable Property Tax Payable Senior Loan Interest Payable Construction Loan Interest Payable Total Liabilities 2,917 15,488,250 2,193,515 4,509 3,663 4,274 5,401 8,689 10,427 3,710 14,628 77,441 12,796 17,830,220 15,488,250 2,193,515 4,599 3,737 4,359 5,509 8,863 10,635 3,785 14,920 77,441 12,796 17,828,409 15,488,250 2,193,515 4,691 3,811 4,447 5,619 9,040 10,848 3,860 15,219 77,441 12,796 17,829,537 Stockholders' Equity Common Stock Retained Earnings Total Stockholders Equity 5,000,000 (749,259) 4,250,741 5,000,000 (939,095) 4,060,905 5,000,000 (1,081,446) 3,918,554 5,000,000 9,154,373 14,154,373 Total Liabilities and Stockholders Equity 22,080,961 21,889,314 21,748,091 14,154,373 Debt to Equity Year 1 Year 2 Year 3 Year 4 Total Stockholders Equity Total Liabilities 4,250,741 17,830,220 4,060,905 17,828,409 3,918,554 17,829,537 14,154,373 Equity Debt 23.84% 76.16% 22.78% 77.22% 21.98% 78.02%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started