Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Business

Authors: Peter Scott

3rd Edition

0198807791, 978-0198807797

More Books

Students also viewed these Accounting questions

Question

How we can improve our listening skills?

Answered: 1 week ago

Question

How do artifacts affect interaction between members of the team?

Answered: 1 week ago