Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a financial ratio analysis from the information provided. Condensed Income Statement of at the end of month of January, February and March. Week 4
Create a financial ratio analysis from the information provided.
Condensed Income Statement of at the end of month of January, February and March.
Week 4 Week 8 Week 12
January to Date | % of Rev. | February to Date | % of Rev. | March to Date | % of Rev. | |
Revenue | $36,513.30 | 100% | $64,295.60 | 100% | $83,726.24 | 100% |
COGS | $3,401.97 | 9% | $6,211.36 | 10% | $8,206.81 | 10% |
Gross Margin | $33,111.33 | 91% | $58,084.24 | 90% | $75,519.43 | 90% |
Management | $7,525.00 | 21% | $9,062.26 | 14% | $9,030.00 | 11% |
Staff | $8,015.20 | 22% | $15,391.22 | 24% | $21,754.36 | 26% |
Advertisement /Promotion | $10,360.00 | 28% | $8,400.00 | 13% | $12,600.00 | 15% |
Rent | $2,000.00 | 5% | $2,000.00 | 3% | $2,000.00 | 2% |
Utilities | $0.00 | 0% | $530.00 | 1% | $530.00 | 1% |
Depreciation Expense | $0.00 | 0% | $0.00 | 0% | $0.00 | 0% |
Interest on Loan | $208.33 | 1% | $208.33 | 0% | $208.33 | 0% |
Other | $1,000.00 | 3% | $950.00 | 1% | $1,850.00 | 2% |
Total Expenses | $29,108.53 | 80% | $36,541.81 | 57% | $47,972.69 | 57% |
Net Income | $4,002.80 | 11% | $21,542.43 | 34% | $27,546.74 | 33% |
Condensed Balance Sheet of end of month for January, February and March.
Week 4 Week 8 Week 12
Assets | Amount | Amount | Amount |
Cash | $10,189.27 | $33,865.06 | $62,599.65 |
Deposits | $2,500.00 | $2,500.00 | $2,500.00 |
Equipment | $14,000.00 | $14,000.00 | $14,000.00 |
Accumulated Depreciation | $0.00 | -$233.33 | -$466.66 |
Inventory | $613.53 | $578.17 | $904.60 |
Prepaid Expenses | $1,700.00 | $1,559.00 | $1,418.00 |
Total Assets | $29,002.80 | $52,268.90 | $80,955.59 |
Liabilities | Amount | Amount | Amount |
Taxes Payable | $0.00 | $0.00 | $0.00 |
Loans | $25,000.00 | $25,000.00 | $25,000.00 |
Total Liabilities | $25,000.00 | $25,000.00 | $25,000.00 |
Equity | Amount | Amount | Amount |
Retained Earnings | $4,002.80 | $27,268.90 | $55,955.59 |
Total Equity | $4,002.80 | $27,268.90 | $55,955.59 |
Total Liabilities & Equity | $29,002.80 | $52,268.90 | $80,955.59 |
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