Answered step by step
Verified Expert Solution
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
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 based on financial plan forecast below: balance sheet , income statement and cash flow statement
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