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 with AI-Powered 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

Organisational Behaviour In The Workplace

Authors: Jacqueline Mclean, Laurie Mullins

12th Edition

1292245484, 978-1292245485

Students also viewed these Accounting questions