Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the information circled in the below image, solve for Interest on Mortgages/Loans in the Pro Forma Statement NOTE: 202X is 2022 and 202Y is
Using the information circled in the below image, solve for Interest on Mortgages/Loans in the Pro Forma Statement
NOTE: 202X is 2022 and 202Y is 2023
Pro Forma Income Statement | |
Make It So Kitchens & Cabinets | |
for Fiscal 2023 | |
REVENUE | |
Sales of Cabinets | 7,200,000 |
Sales of Refurbishing | 1,680,000 |
TOTAL REVENUE | 8,880,000 |
- | - |
COGS | |
Wages & Benefits | 2,650,000 |
Materials | 3,220,000 |
Equipment and Depreciation | 36,000 |
Freight and Shipping | 214,000 |
TOTAL COGS | 6,120,000 |
- | - |
GROSS PROFIT | 2,760,000 |
- | - |
SELLING, GENERAL, & ADMIN EXPENSES | |
Personnel Costs | 650,000 |
Commissions | IGNORE |
Credit Card Fees | 90,000 |
Insurance | 13,800 |
Interest on Mortgages/Loans | ? - Solve for this |
Marketing Expenses | 120,000 |
Office Expenses | 76,600 |
Property Taxes | 86,000 |
Repairs and Maintenance | 50,000 |
Rent - Downtown Office | |
Consultant - Computer Systems | 30,000 |
TOTAL SELLING, GENERAL, & ADMIN EXPENSES | 1,116,400 |
Use the below Balance Sheet IF NEEDED:
Balance Sheet | ||
Make it so Kitchens & Cabinets | ||
For year ending December 31, 2022 | ||
ASSETS | ||
Current Assets | ||
Cash | - | 1,042,900 |
Acounts Receivable | - | 780,000 |
Finished Inventory | - | 2,240,000 |
Prepaid Insurance | - | 3,600 |
Shop Supplies | - | 990,000 |
Short Term Investments (6 - 12 mos.) | - | 750,000 |
Total Current Assets | 5,806,500 | |
- | - | - |
Long-Term Assets | ||
Long Term Investments (> 1 yr.) | 1,400,000 | |
Land & Buildings | 6,750,000 | |
Shop Machinery | 552,500 | |
Less: Accumulated Depreciation | 144,000 | Total: 408,500 |
Total Long-Term Assets | 8,558,500 | |
TOTAL ASSETS | 14,365,000 | |
- | - | - |
LIABILITIES | ||
Current Liabilities | ||
Accounts Payable | 690,000 | |
Commercial Paper | 810,000 | |
Total Current Liabilities | 1,500,000 | |
- | - | - |
Long-Term Liabilities | ||
Loans Payable | 540,000 | |
Mortgage Payable | 3,100,000 | |
Total Long-Term Liabilities | 3,640,000 | |
TOTAL LIABILITIES | 5,140,000 | |
- | - | - |
STOCKHOLDER'S EQUITY | ||
Common Stock | 7,500,000 | |
Preferred Stock | 1,750,000 | |
Retained Earnings (Fiscal 2022) | 975,000 | |
TOTAL STOCKHOLDER'S EQUITY | 10,225,000 | |
TOTAL LIABILITIES AND EQUITY | 15,365,000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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