Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a startup expense and capitalization for a E-Learning application (like ZOOM , microsoft team, google classroom) with 10 million (cash) investment based on financial

Write a startup expense and capitalization for a E-Learning application (like ZOOM , microsoft team, google classroom) with 10 million (cash) investment
based on financial plan forecast below: balance sheet , income statement and cash flow statement
image text in transcribed
image text in transcribed
image text in transcribed
Balance Sheet Forecast Start-up Balance Sheets - Baht in Millions Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Current assets: 10,000,000 6,000,000 4,300,000 5,700,000 11,670,000 22,771,000 Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Accounts receivable, net of allowance for doubtful accounts Total current assets 200.000 300,000 450,000 675,000 1,012,500 1.518,750 10,200,000 6,300,000 4.750,000 6,375,000 12,682,500 24,289,750 Property, plant and equipment, net 50,000 50.000 130,000 130,000 130,000 130,000 Total assets 10.250,000 6,350,000 4,880,000 6,505,000 12,812,500 24,419.750 Debt 10,250,000 8,250,000 8.250,000 8,250,000 6,250,000 4.250.000 Total liabilities 10.250.000 8,250,000 8.250.000 8,250,000 6,250,000 4,250,000 Retained earning -1,900.000 -3,370,000 -1,745,000 6,562,500 20,169.750 Total liabilities, temporary equity, and stockholders' equity 10,250,000 6,350,000 4,880,000 6,505,000 12,812,500 24,419.750 Income Statement Forecast Start-up Statements of Income - Baht ($) Year 1 Year 2 Year 3 Year 4 Year 5 Total Revenue 5,000,000 6,000,000 9,000,000 18,000,000 27,000,000 Cost of Revenue 2,000,000 2,200,000 2,750,000 4,125,000 6,187,500 Gross Profit 3,000,000 3,800,000 6.250,000 13,875,000 20,812,500 Operating Expense Selling General and Administrative 2,000,000 2,200,000 2,750,000 4.125,000 6,187,500 Marketing Expense 2,500,000 2,000,000 1,600,000 1,280,000 1,024,000 500,000 500,000 500,000 500,000 500,000 Research & Development Total expense Operating Income 5,000,000 4,700,000 4,850,000 5,905,000 7,711,500 -2,000,000 -900,000 1,400,000 7.970,000 13,101,000 Tax expense 420,000 2,391,000 3,930,300 Net income -2,000,000 -900,000 980,000 5,579,000 9.170.700 Cash Flow Forecast Start-up Statements of Cash Flows - Baht (8) Year1 Year2 Year3 Year4 Year5 3,000,000 3,800,000 6,250,000 13,875,000 20,812,500 Total Receipts Total Disbursements 7,000,000 5,500,000 4.850,000 7,905,000 9,711,500 Beginning Balance 10,000,000 6,000,000 4,300,000 5,700,000 11,670,000 -4,000,000 -1,700,000 1,400,000 5,970,000 11,101,000 Net Cash Flow Ending Balance 6,000,000 4,300,000 5,700,000 11,670,000 22,771,000 Net Cash Flow per Year 12000000 10000000 3000000 6000000 4000000 2000000 0 Year Yence Year3 Year Yes 5 2000000 -4000000 -6000000 Balance Sheet Forecast Start-up Balance Sheets - Baht in Millions Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Current assets: 10,000,000 6,000,000 4,300,000 5,700,000 11,670,000 22,771,000 Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Accounts receivable, net of allowance for doubtful accounts Total current assets 200.000 300,000 450,000 675,000 1,012,500 1.518,750 10,200,000 6,300,000 4.750,000 6,375,000 12,682,500 24,289,750 Property, plant and equipment, net 50,000 50.000 130,000 130,000 130,000 130,000 Total assets 10.250,000 6,350,000 4,880,000 6,505,000 12,812,500 24,419.750 Debt 10,250,000 8,250,000 8.250,000 8,250,000 6,250,000 4.250.000 Total liabilities 10.250.000 8,250,000 8.250.000 8,250,000 6,250,000 4,250,000 Retained earning -1,900.000 -3,370,000 -1,745,000 6,562,500 20,169.750 Total liabilities, temporary equity, and stockholders' equity 10,250,000 6,350,000 4,880,000 6,505,000 12,812,500 24,419.750 Income Statement Forecast Start-up Statements of Income - Baht ($) Year 1 Year 2 Year 3 Year 4 Year 5 Total Revenue 5,000,000 6,000,000 9,000,000 18,000,000 27,000,000 Cost of Revenue 2,000,000 2,200,000 2,750,000 4,125,000 6,187,500 Gross Profit 3,000,000 3,800,000 6.250,000 13,875,000 20,812,500 Operating Expense Selling General and Administrative 2,000,000 2,200,000 2,750,000 4.125,000 6,187,500 Marketing Expense 2,500,000 2,000,000 1,600,000 1,280,000 1,024,000 500,000 500,000 500,000 500,000 500,000 Research & Development Total expense Operating Income 5,000,000 4,700,000 4,850,000 5,905,000 7,711,500 -2,000,000 -900,000 1,400,000 7.970,000 13,101,000 Tax expense 420,000 2,391,000 3,930,300 Net income -2,000,000 -900,000 980,000 5,579,000 9.170.700 Cash Flow Forecast Start-up Statements of Cash Flows - Baht (8) Year1 Year2 Year3 Year4 Year5 3,000,000 3,800,000 6,250,000 13,875,000 20,812,500 Total Receipts Total Disbursements 7,000,000 5,500,000 4.850,000 7,905,000 9,711,500 Beginning Balance 10,000,000 6,000,000 4,300,000 5,700,000 11,670,000 -4,000,000 -1,700,000 1,400,000 5,970,000 11,101,000 Net Cash Flow Ending Balance 6,000,000 4,300,000 5,700,000 11,670,000 22,771,000 Net Cash Flow per Year 12000000 10000000 3000000 6000000 4000000 2000000 0 Year Yence Year3 Year Yes 5 2000000 -4000000 -6000000

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_2

Step: 3

blur-text-image_3

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

The First Time Homebuyers Handbook

Authors: Dean Thompson

1st Edition

1658856112, 978-1658856119

More Books

Students also viewed these Finance questions

Question

3. Describe the strategic training and development process.

Answered: 1 week ago

Question

10. Microsoft Corporation

Answered: 1 week ago

Question

4. EMC Corporation

Answered: 1 week ago