Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi need help matching these ratios: External Investor's Ownership Percentage for the project using Discounted Cash Flow Valuation, External Investor's Ownership Percentage for the project

Hi need help matching these ratios: External Investor's Ownership Percentage for the project using Discounted Cash Flow Valuation, External Investor's Ownership Percentage for the project using P/EBITDA Multiple Valuation, External Investor's Ownership Percentage for the project using P/S Ratio Multiple Valuation, External Investor's Ownership Percentage for the project using Replacement Cost valuation, External Investor's Ownership Percentage using P/E Multiple Valuation

These are the options: 18.07%,19.10%,51.02%,28.90%,20.10%

Thanks very much.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Income Sheet Data Total Revenues Less: cost of goods sold Gross Profit Year 1 385,175 145,831 239,344 Year 2 5,255,918 2,339,748 2,916,170 Year 3 15,308,918 6,976,281 8,332,637 Year 4 28,331,826 12,950,174 15,381,653 Year 5 43,056,068 19,680,466 23,375,602 Operating Expense 2,005,653 2,963,656 4,382,708 6,486,454 9,607,911 Interest Expense Depreciation Investment Income 48,533 425,399 70,666 611,399 100,254 424,732 99,974 400,149 74,533 400,149 (2,240,240) (729,550) Income Before Taxes Tax Expense Net Income 3,424,943 136,546 3,288,397 8,395,076 2,518,523 5,876,553 13,293,009 3,987,903 9,305,106 (2,240,240) (729,550) Cash Flow Sheet Year 1 Year 2 Year 3 Year 4 Year 5 (2,240,240) (729,550) 3,288,397 5,876,553 9,305,106 Operations Net Income (Loss) Adjustments to Net Income Accounts Payable Depreciation/Amortization Inventory Accounts Receivable Investment Income Cash Flow from Operations 30,455 425,399 (54,435) (182,399) 42,693 611,399 (114,139) (435,139) 100,527 424,732 (911,750) (1,189,493) 102,933 400,149 (744,285) (1,272,810) 110,253 400,149 (746,561) (1,239,739) (2,021,220) (624,736) 1,712,414 4,362,540 7,829,208 Investments Property & Equipment Cash Flow from Operations (2,506,994) (2,506,994) (2,150,000) (2,150,000) Cash Flow before Financing (4,528,214) (624,736) (437,586) 4,362,540 7,829,208 Financing Company Funds Proceeds of Debt Reductions to Debt Cash Flow from Financing 5,000,000 1,706,994 (177,507) 6,529,488 (316,830) (316,830) 1,827,500 (455,205) 1,372,295 (533,527) (533,527) (551,841) (551,841) Cash Flow before Equity (2,998,727) (941,566) 934,709 3,829,013 7,277,367 Beginning Cash Balance Net Cash Flow Ending Cash Balance 2,001,273 2,001,273 2,001,273 (941,566) 1,059,707 1,059,707 934,709 1,994,416 1,994,416 3,829,013 5,823,429 5,823,429 7,277,367 13,100,796 Balance Sheet Year 1 Year 2 Year 3 Year 4 Year 5 Assets Current Assets Cash Accounts Recievable Inventory Total Current Assets 2,001,273 182,399 54,435 2,238,107 1,059,707 617,538 168,574 1,845,818 1,994,416 1,807,030 1,080,323 4,881,769 5,823,429 3,079,841 1,824,608 10,727,878 13,100,796 4,319,580 2,571,170 19,991,546 Long Term Assets Property & Equipment Accumulated Depreciation Total Long Term Assets Total Assets 2,506,994 (425,399) 2,081,595 4,319,702 2,506,994 (1,036,798) 1,470,196 3,316,015 4,656,994 (1,461,530) 3,195,464 8,077,233 4,656,994 (1,861,679) 2,795,315 13,523,193 4,656,994 (2,261,828) 2,395,166 22,386,712 Liabilities Current Liabilities Accounts Payable Equipment Loan Building Loan Current Portion of LTD Total Current Liabilities 30,455 316,830 73,148 333,372 173,674 350,777 182,750 533,527 707,201 276,608 369,091 182,750 551,841 828,448 386,861 159,418 182,750 342,168 729,029 316,830 347,285 333,372 406,519 1,212,657 879,286 Long-Term Liabilities Equipment Loan Building Loan Total Long Term Liabilities Total Liabilities 528,509 1,522,917 2,051,426 2,758,627 159,418 1,340,167 1,499,585 2,328,033 1,212,657 1,559,943 879,286 1,285,805 1,157,417 1,157,417 1,886,446 Stock Issued Retained Earnings Owners Equity Total liabilities & Fauity 5,000,000 (2,240,240) 2,759,760 5,000,000 (2,969,791) 2,030,209 3 316015 5,000,000 318,607 5,318,607 8 077 233 5,000,000 5,000,000 6,195,160 15,500,266 11,195,160 20,500,266 13 523 19322 386 712 Valuation Data Replacement Cost Data Discount Rate (APY) Cash Flow growth rate Finance Rate Reinvestment Rate Continuing Value Growth Rate 20.00% 11.00% 6.50% 6.50% 3.00% Cost to Replace Replacement Time (months) $4,000,000 12 Company Funds $5,000,000 Fiscal Year Ends in 1 Feb-17 2 Feb-18 4 Feb-20 Feb-16 Feb-19 Feb-21 (2,998,727) (941,566) 934,709 3,829,013 7,277,367 ?? Cash Flow Before Equity Continuing Value Total Cash Flow Discounted Cash Flow Net Present Value (NPV) Annual Equivalent (2,998,727) ($2,498,939) (941,566) ($653,866) 934,709 $540,919 3,829,013 $1,846,553 ?? Comparable P/S Ratio Comparable P/EBITDA Ratio Comparable P/E Ratio 1.0 5.0 Income Sheet Data Total Revenues Less: cost of goods sold Gross Profit Year 1 385,175 145,831 239,344 Year 2 5,255,918 2,339,748 2,916,170 Year 3 15,308,918 6,976,281 8,332,637 Year 4 28,331,826 12,950,174 15,381,653 Year 5 43,056,068 19,680,466 23,375,602 Operating Expense 2,005,653 2,963,656 4,382,708 6,486,454 9,607,911 Interest Expense Depreciation Investment Income 48,533 425,399 70,666 611,399 100,254 424,732 99,974 400,149 74,533 400,149 (2,240,240) (729,550) Income Before Taxes Tax Expense Net Income 3,424,943 136,546 3,288,397 8,395,076 2,518,523 5,876,553 13,293,009 3,987,903 9,305,106 (2,240,240) (729,550) Cash Flow Sheet Year 1 Year 2 Year 3 Year 4 Year 5 (2,240,240) (729,550) 3,288,397 5,876,553 9,305,106 Operations Net Income (Loss) Adjustments to Net Income Accounts Payable Depreciation/Amortization Inventory Accounts Receivable Investment Income Cash Flow from Operations 30,455 425,399 (54,435) (182,399) 42,693 611,399 (114,139) (435,139) 100,527 424,732 (911,750) (1,189,493) 102,933 400,149 (744,285) (1,272,810) 110,253 400,149 (746,561) (1,239,739) (2,021,220) (624,736) 1,712,414 4,362,540 7,829,208 Investments Property & Equipment Cash Flow from Operations (2,506,994) (2,506,994) (2,150,000) (2,150,000) Cash Flow before Financing (4,528,214) (624,736) (437,586) 4,362,540 7,829,208 Financing Company Funds Proceeds of Debt Reductions to Debt Cash Flow from Financing 5,000,000 1,706,994 (177,507) 6,529,488 (316,830) (316,830) 1,827,500 (455,205) 1,372,295 (533,527) (533,527) (551,841) (551,841) Cash Flow before Equity (2,998,727) (941,566) 934,709 3,829,013 7,277,367 Beginning Cash Balance Net Cash Flow Ending Cash Balance 2,001,273 2,001,273 2,001,273 (941,566) 1,059,707 1,059,707 934,709 1,994,416 1,994,416 3,829,013 5,823,429 5,823,429 7,277,367 13,100,796 Balance Sheet Year 1 Year 2 Year 3 Year 4 Year 5 Assets Current Assets Cash Accounts Recievable Inventory Total Current Assets 2,001,273 182,399 54,435 2,238,107 1,059,707 617,538 168,574 1,845,818 1,994,416 1,807,030 1,080,323 4,881,769 5,823,429 3,079,841 1,824,608 10,727,878 13,100,796 4,319,580 2,571,170 19,991,546 Long Term Assets Property & Equipment Accumulated Depreciation Total Long Term Assets Total Assets 2,506,994 (425,399) 2,081,595 4,319,702 2,506,994 (1,036,798) 1,470,196 3,316,015 4,656,994 (1,461,530) 3,195,464 8,077,233 4,656,994 (1,861,679) 2,795,315 13,523,193 4,656,994 (2,261,828) 2,395,166 22,386,712 Liabilities Current Liabilities Accounts Payable Equipment Loan Building Loan Current Portion of LTD Total Current Liabilities 30,455 316,830 73,148 333,372 173,674 350,777 182,750 533,527 707,201 276,608 369,091 182,750 551,841 828,448 386,861 159,418 182,750 342,168 729,029 316,830 347,285 333,372 406,519 1,212,657 879,286 Long-Term Liabilities Equipment Loan Building Loan Total Long Term Liabilities Total Liabilities 528,509 1,522,917 2,051,426 2,758,627 159,418 1,340,167 1,499,585 2,328,033 1,212,657 1,559,943 879,286 1,285,805 1,157,417 1,157,417 1,886,446 Stock Issued Retained Earnings Owners Equity Total liabilities & Fauity 5,000,000 (2,240,240) 2,759,760 5,000,000 (2,969,791) 2,030,209 3 316015 5,000,000 318,607 5,318,607 8 077 233 5,000,000 5,000,000 6,195,160 15,500,266 11,195,160 20,500,266 13 523 19322 386 712 Valuation Data Replacement Cost Data Discount Rate (APY) Cash Flow growth rate Finance Rate Reinvestment Rate Continuing Value Growth Rate 20.00% 11.00% 6.50% 6.50% 3.00% Cost to Replace Replacement Time (months) $4,000,000 12 Company Funds $5,000,000 Fiscal Year Ends in 1 Feb-17 2 Feb-18 4 Feb-20 Feb-16 Feb-19 Feb-21 (2,998,727) (941,566) 934,709 3,829,013 7,277,367 ?? Cash Flow Before Equity Continuing Value Total Cash Flow Discounted Cash Flow Net Present Value (NPV) Annual Equivalent (2,998,727) ($2,498,939) (941,566) ($653,866) 934,709 $540,919 3,829,013 $1,846,553 ?? Comparable P/S Ratio Comparable P/EBITDA Ratio Comparable P/E Ratio 1.0 5.0

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

Students also viewed these Accounting questions