Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

what is the: Return on sales? Profit margin of each brand? Return on investment for venture capitalists? Estimated ROI proposed to the VCs? Estimated share

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

what is the:

Return on sales?

Profit margin of each brand?

Return on investment for venture capitalists?

Estimated ROI proposed to the VCs?

Estimated share price in Q6?

Realized earings per share in Q6?

Price= 30 per share if earning per share

Realized ROI for your VCs

B D E F G Income Statement Report Item Quarter 4 Quarter 5 Quarter 6 Revenues - Rebates - Cost of Goods Sold = Gross Profit OOO 3,288,930 13,075 1,339,620 1,936,235 6,228,459 20,100 2,315,613 3,892,746 9,919,371 27,400 3,898,753 5,993,218 Research and Development + Advertising + Internet Marketing Expenses + Sales Force Expense + Store and Web Sales Center Expenses + Web Sales Productivity Expenses + Marketing Research + Shipping + Excess Capacity Cost + Depreciation Total Expenses Operating Profit 1,966,533 215,278 18,950 204,957 183,000 36,000 20,000 30,462 0 50,000 2,725,180 -788,945 Quarter 1 Quarter 2 Quarter 3 Gross Profit 513,775 1,360,370 2,125 3,460 259,574 551,359 0 252,076 805,551 Expenses 90,000 0 60,000 0 90,500 107,871 0 3,000 3,000 0 51,795 144,149 350,000 258,000 256,000 0 6,000 52,000 0 20,000 20,000 0 7,362 15,307 0 0 0 0 20,000 30,000 440,000 456,657 688,327 -440,000 -204,581 117,224 Miscellaneous Income and Expenses 0 0 0 0 0 0 0 0 0 -440,000 -204,581 117,224 4,650 4,650 1,710 0 0 0 -435,350 -199,931 118,934 0 118,934 0 0 0 0 0 -435,350 -199,931 118,934 -29 -10 5 456,560 267,957 84,950 295,350 267,000 27,000 20,000 48,560 0 90,000 1,557,377 2,335,369 370,505 357,091 193,967 485,698 196,000 115,000 20,000 70,524 0 110,000 1,918,785 4,074,433 Ooo > 0 O O O 0 0 0 0 0 0 Ooo 0 o 0 0 + Licensing Income - Licensing Fees + Other Income - Other Expenses = Earnings Before Interest and Taxes + Interest Income - Interest Charges = Income Before Taxes - Loss Carry Forward = Taxable income - Income Taxes = Net Income Earnings per Share OO -788,945 0 0 -788,945 0 0 0 -788,945 -20 2,335,369 0 0 2,335,369 1,305,292 1,030,077 412,031 1,923,339 49 4,074,433 0 0 4,074,433 0 4,074,433 1,629,773 2,444,660 63 Cash Flow Report Item Beginning Cash Balance Quarter 4 719,653 Quarter 5 874,708 Quarter 6 2,408,046 Revenues - Rebates Production -Research and Development -Advertising - Internet Marketing Expenses - Sales Force Expense - Store and Web Sales Center Expenses - Web Sales Productivity Expenses - Marketing Research - Shipping - Excess Capacity Cost - Income Taxes + Interest Income Interest Charges + Licensing Income - Licensing Fees + Other Income - Other Expenses = Net Operating Cash Flow 3,288,930 13,075 1,339,620 1,966,533 215,278 18,950 204,957 183,000 36,000 20,000 30,462 0 6,228,459 20,100 2,315,613 456,560 267,957 84,950 295,350 267,000 27,000 20,000 48,560 0 412,031 0 0 0 0 0 0 2,013,339 9,919,371 27,400 3,898,753 370,505 357,091 193,967 485,698 196,000 115,000 20,000 70,524 0 1,629,773 0 0 0 0 Quarter 1 Quarter 2 Quarter 3 0 274,650 354,719 Receipts and Disbursements from Operating Activities 0 513,775 1,360,370 0 2,125 3,460 0 259,574 551,359 90,000 0 60,000 0 90,500 107,871 0 3,000 3,000 0 51,795 144,149 350,000 258,000 256,000 0 6,000 52,000 0 20,000 20,000 0 7,362 15,307 0 0 0 4,650 4,650 1,710 0 0 0 0 0 0 0 0 0 0 -435,350 -179,931 148,934 Investing Activities 480,000 240,000 480,000 480,000 240,000 480,000 Financing Activities 1,500,000 500,000 500,000 0 0 0 0 0 0 0 0 0 0 310,000 0 0 0 0 196,000 1,190,000 500,000 696,000 274,650 354,719 719,653 OOOO OOOOO 0 OOOG 0 0 0 0 0 0 -738,945 OOOOOO oooooo 0 0 0 2,554,660 Fixed Production Capacity = Total Investing Activities 960,000 960,000 480,000 480,000 480,000 480,000 1,740,000 0 0 0 0 0 Increase in Common Stock + Borrow Conventional Loan Repay Conventional Loan + Borrow Emergency Loan - Repay Emergency Loan - Deposit 3 Month Certificate + Withdraw 3 Month Certificate = Total Financing Activities Cash Balance, End of Period BOOOO 0 Oo oo OOOOOOOO 0 0 0 0 0 114,000 1,854,000 874,708 0 0 0 2,408,046 0 4,482,706 Balance Sheet Report Item Quarter 3 Quarter 4 Quarter 5 Quarter 6 Cash +3 Month Certificate of Deposit 719,653 114,000 874,708 0 2,408,046 0 4,482,706 0 + Net Fixed Assets = Total 1,150,000 1,983,653 2,060,000 2,934,708 2,450,000 4,858,046 2,820,000 7,302,706 Quarter 1 Quarter 2 Current Assets 274,650 354,719 310,000 310,000 Long Term Assets 480,000 700,000 1,064,650 1,364,719 Debt 0 0 0 0 Equity 1,500,000 2,000,000 435,350 -635,281 1,064,650 1,364,719 Conventional Bank Loan + Emergency Loan 0 0 0 0 0 0 0 0 + Common Stock + Retained Earnings = Total 2,500,000 -516,347 1,983,653 4,240,000 -1,305,292 2,934,708 4,240,000 618,046 4,858,046 4,240,000 3,062,706 7,302,706 Average Rider N/A N/A 3.08 1.45 3.52 1.36 0.00 Industry Financial Ratios Ratio Lowest Highest Liquidity Ratios Quick Liquidity Test Ratio N/A N/A Activity Ratios Fixed Assets Turnover 2.25 3.52 Total Assets Turnover 0.91 2.18 Leverage Ratios Debt Ratio 0.00 0.00 Debt to Paid-In Capital 0.00 0.00 Profitability Ratios Gross Profit Margin 51.11 63.80 Net Profit Margin 1.99 24.65 Return on Assets 1.81 43.74 Return on Paid-In Capital 1.81 43.74 Financial Statement Highlights Revenues 4,508,500 9,919,371 Gross Profit 2,736,726 5,993,218 Net Income 89,556 2,444,660 0.00 0.00 0.00 59.01 17.35 27.48 27.48 60.42 24.65 33.48 33.48 8,029,308 4,724,408 1,579,568 9,919,371 5,993,218 2,444,660 Stock History Stock Type Common Stock Common Stock Common Stock Common Stock Name of Owner Executive Team Executive Team Executive Team Venture Capitalists Shares 15,000 5,000 5,000 13,920 Price Per Share 100 100 100 125 Total Amount 1,500,000 500,000 500,000 1,740,000 Quarter 1 2 3 HNm 4 Lost Sales Due to Stock-outs Rebates Sales - Total Brand Offroad Rider 3 Ghost Rider 3 Lane Rider 2 Trail Rider 2 Wind Rider 3 Total Net Demand 1,144 1,334 1,097 1,229 1,790 6,594 Units Sold 1,144 1,334 1,097 1,229 1,790 6,594 OOOOOO Sales Revenue 1,618,760 2,253,126 1,316,400 1,689,875 3,041,210 9,919,371 0 0 27,400 Cost of Goods Sold 638,095 887,230 505,764 675,699 1,191,966 3,898,753 Gross Margin 980,665 1,365,896 783,236 1,014,176 1,849,244 5,993,218 0 27,400 B D E F G Income Statement Report Item Quarter 4 Quarter 5 Quarter 6 Revenues - Rebates - Cost of Goods Sold = Gross Profit OOO 3,288,930 13,075 1,339,620 1,936,235 6,228,459 20,100 2,315,613 3,892,746 9,919,371 27,400 3,898,753 5,993,218 Research and Development + Advertising + Internet Marketing Expenses + Sales Force Expense + Store and Web Sales Center Expenses + Web Sales Productivity Expenses + Marketing Research + Shipping + Excess Capacity Cost + Depreciation Total Expenses Operating Profit 1,966,533 215,278 18,950 204,957 183,000 36,000 20,000 30,462 0 50,000 2,725,180 -788,945 Quarter 1 Quarter 2 Quarter 3 Gross Profit 513,775 1,360,370 2,125 3,460 259,574 551,359 0 252,076 805,551 Expenses 90,000 0 60,000 0 90,500 107,871 0 3,000 3,000 0 51,795 144,149 350,000 258,000 256,000 0 6,000 52,000 0 20,000 20,000 0 7,362 15,307 0 0 0 0 20,000 30,000 440,000 456,657 688,327 -440,000 -204,581 117,224 Miscellaneous Income and Expenses 0 0 0 0 0 0 0 0 0 -440,000 -204,581 117,224 4,650 4,650 1,710 0 0 0 -435,350 -199,931 118,934 0 118,934 0 0 0 0 0 -435,350 -199,931 118,934 -29 -10 5 456,560 267,957 84,950 295,350 267,000 27,000 20,000 48,560 0 90,000 1,557,377 2,335,369 370,505 357,091 193,967 485,698 196,000 115,000 20,000 70,524 0 110,000 1,918,785 4,074,433 Ooo > 0 O O O 0 0 0 0 0 0 Ooo 0 o 0 0 + Licensing Income - Licensing Fees + Other Income - Other Expenses = Earnings Before Interest and Taxes + Interest Income - Interest Charges = Income Before Taxes - Loss Carry Forward = Taxable income - Income Taxes = Net Income Earnings per Share OO -788,945 0 0 -788,945 0 0 0 -788,945 -20 2,335,369 0 0 2,335,369 1,305,292 1,030,077 412,031 1,923,339 49 4,074,433 0 0 4,074,433 0 4,074,433 1,629,773 2,444,660 63 Cash Flow Report Item Beginning Cash Balance Quarter 4 719,653 Quarter 5 874,708 Quarter 6 2,408,046 Revenues - Rebates Production -Research and Development -Advertising - Internet Marketing Expenses - Sales Force Expense - Store and Web Sales Center Expenses - Web Sales Productivity Expenses - Marketing Research - Shipping - Excess Capacity Cost - Income Taxes + Interest Income Interest Charges + Licensing Income - Licensing Fees + Other Income - Other Expenses = Net Operating Cash Flow 3,288,930 13,075 1,339,620 1,966,533 215,278 18,950 204,957 183,000 36,000 20,000 30,462 0 6,228,459 20,100 2,315,613 456,560 267,957 84,950 295,350 267,000 27,000 20,000 48,560 0 412,031 0 0 0 0 0 0 2,013,339 9,919,371 27,400 3,898,753 370,505 357,091 193,967 485,698 196,000 115,000 20,000 70,524 0 1,629,773 0 0 0 0 Quarter 1 Quarter 2 Quarter 3 0 274,650 354,719 Receipts and Disbursements from Operating Activities 0 513,775 1,360,370 0 2,125 3,460 0 259,574 551,359 90,000 0 60,000 0 90,500 107,871 0 3,000 3,000 0 51,795 144,149 350,000 258,000 256,000 0 6,000 52,000 0 20,000 20,000 0 7,362 15,307 0 0 0 4,650 4,650 1,710 0 0 0 0 0 0 0 0 0 0 -435,350 -179,931 148,934 Investing Activities 480,000 240,000 480,000 480,000 240,000 480,000 Financing Activities 1,500,000 500,000 500,000 0 0 0 0 0 0 0 0 0 0 310,000 0 0 0 0 196,000 1,190,000 500,000 696,000 274,650 354,719 719,653 OOOO OOOOO 0 OOOG 0 0 0 0 0 0 -738,945 OOOOOO oooooo 0 0 0 2,554,660 Fixed Production Capacity = Total Investing Activities 960,000 960,000 480,000 480,000 480,000 480,000 1,740,000 0 0 0 0 0 Increase in Common Stock + Borrow Conventional Loan Repay Conventional Loan + Borrow Emergency Loan - Repay Emergency Loan - Deposit 3 Month Certificate + Withdraw 3 Month Certificate = Total Financing Activities Cash Balance, End of Period BOOOO 0 Oo oo OOOOOOOO 0 0 0 0 0 114,000 1,854,000 874,708 0 0 0 2,408,046 0 4,482,706 Balance Sheet Report Item Quarter 3 Quarter 4 Quarter 5 Quarter 6 Cash +3 Month Certificate of Deposit 719,653 114,000 874,708 0 2,408,046 0 4,482,706 0 + Net Fixed Assets = Total 1,150,000 1,983,653 2,060,000 2,934,708 2,450,000 4,858,046 2,820,000 7,302,706 Quarter 1 Quarter 2 Current Assets 274,650 354,719 310,000 310,000 Long Term Assets 480,000 700,000 1,064,650 1,364,719 Debt 0 0 0 0 Equity 1,500,000 2,000,000 435,350 -635,281 1,064,650 1,364,719 Conventional Bank Loan + Emergency Loan 0 0 0 0 0 0 0 0 + Common Stock + Retained Earnings = Total 2,500,000 -516,347 1,983,653 4,240,000 -1,305,292 2,934,708 4,240,000 618,046 4,858,046 4,240,000 3,062,706 7,302,706 Average Rider N/A N/A 3.08 1.45 3.52 1.36 0.00 Industry Financial Ratios Ratio Lowest Highest Liquidity Ratios Quick Liquidity Test Ratio N/A N/A Activity Ratios Fixed Assets Turnover 2.25 3.52 Total Assets Turnover 0.91 2.18 Leverage Ratios Debt Ratio 0.00 0.00 Debt to Paid-In Capital 0.00 0.00 Profitability Ratios Gross Profit Margin 51.11 63.80 Net Profit Margin 1.99 24.65 Return on Assets 1.81 43.74 Return on Paid-In Capital 1.81 43.74 Financial Statement Highlights Revenues 4,508,500 9,919,371 Gross Profit 2,736,726 5,993,218 Net Income 89,556 2,444,660 0.00 0.00 0.00 59.01 17.35 27.48 27.48 60.42 24.65 33.48 33.48 8,029,308 4,724,408 1,579,568 9,919,371 5,993,218 2,444,660 Stock History Stock Type Common Stock Common Stock Common Stock Common Stock Name of Owner Executive Team Executive Team Executive Team Venture Capitalists Shares 15,000 5,000 5,000 13,920 Price Per Share 100 100 100 125 Total Amount 1,500,000 500,000 500,000 1,740,000 Quarter 1 2 3 HNm 4 Lost Sales Due to Stock-outs Rebates Sales - Total Brand Offroad Rider 3 Ghost Rider 3 Lane Rider 2 Trail Rider 2 Wind Rider 3 Total Net Demand 1,144 1,334 1,097 1,229 1,790 6,594 Units Sold 1,144 1,334 1,097 1,229 1,790 6,594 OOOOOO Sales Revenue 1,618,760 2,253,126 1,316,400 1,689,875 3,041,210 9,919,371 0 0 27,400 Cost of Goods Sold 638,095 887,230 505,764 675,699 1,191,966 3,898,753 Gross Margin 980,665 1,365,896 783,236 1,014,176 1,849,244 5,993,218 0 27,400

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 Handbook Of Loan Syndications And Trading

Authors: Marsh, Lee Shaiman, Bridget Marsh

2nd Edition

1264258526, 978-1264258529

More Books

Students explore these related Finance questions