Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please elaborate a Cash Flow statement with projected income for the first three years of business, broken down by month considering the numbers below Furniture

Please elaborate a Cash Flow statement with projected income for the first three years of business, broken down by month considering the numbers below

image text in transcribedimage text in transcribed
Furniture (Chair and Desk) $1,950.00 $3,000.00 $8,000.00 Balance Sheet Assets Year 1 Current Assets Cash $867,527.88 Prepaid Expenses Insurance $3 60 . 00 Total Current Assets $867,887.88 No n-Current Assets Year 2 $1,322,935.73 $360.00 $1,823,295.78 Year 3 $2,428,181.73 $360.00 $2,428,541.73 Long Term Investments $0.00 $0.00 $0.00 Property, Plant and Equipment Furniture $1,950.00 $1,560.00 $1,170.00 Furniture, Accumulated Depreciation $390-00 $390.00 $390.00 Computers $6,000.00 $4,800.00 $3,600.00 Computers, Acummulated Depreciation $1 ,200.00 $ 1,200.00 $1,200.00 Cell Phones $3,000.00 $2,400.00 $1,800.00 Cell Phones, Accumulated Depreciation $600.00 $600.00 $600.00 Depreciation cost $2,1 90.00 $2, 1 90 .00 $2, 1 90.00 Total Non-Current Assets $8,760.00 $6,570.00 $4,380.00 Total Assets $876,647.88 $1 ,829,865.78 $2,432,921.73 Liabilities Current Liabilities Accounts Payable $1,591.52 $4,671.52 $8,986.52 Total Current Liabilities $1,591.52 $4,671 .52 $8,986.52 Non-current liabilities Longterm loan $0.00 $0.00 $0.00 Total non-current liabilities $0.00 $0.00 $0.00 Total Liabilities $1,591.52 $4,671.52 $8,986.52 Equity Owner's Equity Total Liabilities and Equity $875,056.36 $1 ,825,194.26 $2,423,935.21 $876,647.88 $1,829,865.78 $2,432,92 1.73 Cost and Expenses Monthly Advertisement $1,000.00 Whatsapp Business $300.00 Sales Apps $120.00 Fido Wireless $100.00 Shcpify Platform $36.52 Total Monthly Cost and Expenses $1,556.52 Annually Insurance $420.00 Depreciation $2,190.00 Total Annall}r Cost and Expenses $2,610.00 Total Cost and Expenses $4,166.52 Income Statement Year 1 Year 2 Year 3 Product Sales $3,995,000.00 $8,400,000.00 $11,200,000.00 Less: Sales Cost $2,996,250.00 $6,300,000.00 $8,400,000.00 Gross Prot $998,750.00 $2,100,000.00 $2,800,000.00 Overhead Expenses Shopify Platform $438.24 $438.24 $438.24 Advertisement $12,000.00 $48,000.00 $96,000.00 Whatsapp Business $3,600.00 $3,600.00 $3,600.00 Fido Wireless $1,200.00 $1,200.00 $1,200.00 Sales Apps $1,440.00 $1,440.00 $3,600.00 Insurance $420.00 $420.00 $420.00 Total Expenses $19,098.24 $55,098.24 $105,258.24 Earnings Before Tax $979,651.76 $2,044,901.76 $2,694,741.76 Interest Expense $0.00 $0.00 $0.00 Tax Expense (13%) $127,354.73 $265,837.23 $350,316.43 Net Prot $852,297.03 $1,779,064.53 $2,344,425.33

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

Principles Of Financial Accounting (Chapters 1-17)

Authors: John Wild

24th Edition

1260158608, 9781260158601

More Books

Students also viewed these Accounting questions