Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Company's name is Costco Wholesales and if you cant find the company pls use another company to answer the question below. i just need

The Company's name is Costco Wholesales and if you cant find the company pls use another company to answer the question below.

i just need steps to answer does questions.

Thank you

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

  1. Estimate cost of equity
    • Select a model for estimating cost of equity, e.g. CAPM
    • Research input values required by the selected model
    • Compute cost of equity
  2. Estimate terminal value
    • Select a model for estimating terminal value
    • Research input values required by the selected model
    • Compute terminal value
  3. Estimate value of equity
    • Combine terminal value with free cash flows to equity from the last assignment to determine total cash flows to equity for your target company
    • Estimate the value of equity by computing the present value of total cash flows to equity using the cost of equity as the discount rate
    • Compute the estimated price per share
  4. Scenario analysis
    • Propose best case and worst case scenarios
    • Compute the value of equity (total and per share) in each scenario
  5. Sensitivity analysis
    • Identify input variable(s) that you consider would have the greatest impact on the estimate equity value
    • Perform sensitivity analysis (e.g. using Data Table in Excel) and compute estimated value of equity per share at different levels of these input variable(s)

Thank you

Income Statement All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Learn more Breakdown TTM 8/31/2020 8/31/2019 8/31/2018 8/31/2017 > Total Revenue 186,637,000 166,761,000 152,703,000 141,576,000 129,025,00 Cost of Revenue 162,352,000 144,939,000 132,886,000 123,152,000 111,882,000 Gross Profit 24,285,000 21,822,000 19,817,000 18,424,000 17,143,000 17,923,000 > Operating Expense 16,387,000 15.080,000 13,944,000 13,032,000 6,362,000 Operating Income 5,435,000 4,737,000 4,480,000 4,111,000 -124,000 > Net Non Operating interest Inc... -71,000 -24,000 -84,000 -84,000 20,000 3,000 52,000 46,000 12,000 > Other Income Expense Pretax Income 6,258,000 5,367,000 4,765,000 4,442,000 4,039,000 Tax Provision 1,469,000 1,308,000 1,061,000 1,263,000 1325,000 4.726,000 > Net Income Common Stockhold... 4,002,000 3,659,000 3,134,000 2,679,000 Diluted NI Available to Com Stock... 4,726,000 4,002,000 3,659,000 2,679,000 3,134,000 9.05 8.32 7.15 6.11 Basic EPS 9.02 8.26 7.09 6.08 Diluted EPS 442,297 439.755 438,515 438,437 Basic Average Shares 443,901 442,923 441,834 440.937 Diluted Average Shares 6,362.000 5,435,000 4,737,000 4,480,000 4,111,000 Total Operating Income as Reported 180,275,000 161.326,000 147,966,000 137,096,000 124,914,000 Total Expenses 180,275,000 161,326,000 147,966,000 137,096,000 124,914,000 Total Expenses 4,726,000 4,002,000 3,659,000 3,134,000 Net Income from Continuing & Dis... 2,679,000 4,717,582 3,996,708 3,638,021 3,117,532 Normalized Income 2,682,360 46,000 89,000 126,000 75,000 50,000 Interest Income 170,000 160,000 Interest Expense 150,000 159,000 134,000 - 124,000 -71,000 -24,000 -84,000 -84,000 Net Interest Income 6,428,000 5,527,000 4,915,000 4,601,000 EBIT 4,173,000 EBITDA 8,155,000 162,352,000 144,939,000 132,886,000 123,152,000 Reconciled Cost of Revenue 111,882,000 1,727,000 1,645,000 1,492,000 1,437,000 1,370,000 Reconciled Depreciation Net Income from Continuing Oper. Total Unusual Items Excluding Goo. 4.726,000 4,002,000 3,659,000 3,134,000 2,679,000 11,000 7,000 27,000 -5,000 23,000 Total Unusual Items 11,000 7,000 27,000 -5,000 23,000 8.144,000 Normalized EBITDA 7,165,000 6,380,000 6,015,000 5,548,000 0 0 0 0 0 Tax Rate for Calcs Tax Effect of Unusual Items 2,582 1,708 6,021 - 1,640 6,532 Balance Sheet All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Learn more 8/31/2020 Breakdown 8/31/2019 8/31/2018 8/31/2017 55,556,000 45,400,000 40,830,000 > Total Assets 36,347,000 36,851,000 29,816,000 27.727,000 > Total Liabilities Net Minority Int... 25,268,000 18,705,000 15,584,000 13,103,000 > Total Equity Gross Minority Inte... 11,079,000 25,798,000 20,367,000 19,286,000 Total Capitalization 17,351,000 18,284,000 Common Stock Equity 15,243,000 12,799,000 10,778,000 Capital Lease Obligations 2,558,000 18,284,000 15,243,000 12,799,000 Net Tangible Assets 10,778,000 3,276,000 Working Capital 248,000 363,000 -178,000 25,893,000 Invested Capital 22,066,000 19,286,000 17,437,000 18,284,000 15,243,000 12,799,000 Tangible Book Value 10,778,000 10,167,000 6,823,000 6,487,000 Total Debt 6,659,000 432,000 2,113,000 Net Debt 441,255 Share issued 439,625 438,189 437,204 441,255 439,625 438,189 437,204 Ordinary Shares Number Cash Flow All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Learn more Breakdown TTM 8/31/2020 8/31/2019 8/31/2018 8/31/2017 10,260,000 8,861,000 6,356,000 5,774,000 6,726,000 > Operating Cash Flow -3,321,000 -3,891,000 > Investing Cash Flow -2,865,000 -2,947,000 -2,366,000 -7,687,000 -1,147,000 > Financing Cash Flow -1,147,000 -1,281,000 -3,218,000 10,078,000 12,277,000 8,384,000 6,055,000 4,546,000 > End Cash Position Income Tax Paid Supplemental Data Interest Paid Supplemental Data 1,461,000 1,052,000 1,187,000 1,204,000 1,185,000 151,000 124,000 141,000 143,000 131,000 -3,346,000 -2,810,000 -2.998,000 -2,969,000 -2,502,000 1,000 3,992,000 298,000 80,000 3,782,000 -1,355,000 Capital Expenditure Issuance of Debt Repayment of Debt Repurchase of Capital Stock Free Cash Flow -3,200,000 -89,000 -86,000 -2,436,000 -452,000 -196,000 -247,000 -328,000 -469,000 6,914,000 6,051,000 3,358,000 2,805,000 4,224,000 Income Statement All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Learn more Breakdown TTM 8/31/2020 8/31/2019 8/31/2018 8/31/2017 > Total Revenue 186,637,000 166,761,000 152,703,000 141,576,000 129,025,00 Cost of Revenue 162,352,000 144,939,000 132,886,000 123,152,000 111,882,000 Gross Profit 24,285,000 21,822,000 19,817,000 18,424,000 17,143,000 17,923,000 > Operating Expense 16,387,000 15.080,000 13,944,000 13,032,000 6,362,000 Operating Income 5,435,000 4,737,000 4,480,000 4,111,000 -124,000 > Net Non Operating interest Inc... -71,000 -24,000 -84,000 -84,000 20,000 3,000 52,000 46,000 12,000 > Other Income Expense Pretax Income 6,258,000 5,367,000 4,765,000 4,442,000 4,039,000 Tax Provision 1,469,000 1,308,000 1,061,000 1,263,000 1325,000 4.726,000 > Net Income Common Stockhold... 4,002,000 3,659,000 3,134,000 2,679,000 Diluted NI Available to Com Stock... 4,726,000 4,002,000 3,659,000 2,679,000 3,134,000 9.05 8.32 7.15 6.11 Basic EPS 9.02 8.26 7.09 6.08 Diluted EPS 442,297 439.755 438,515 438,437 Basic Average Shares 443,901 442,923 441,834 440.937 Diluted Average Shares 6,362.000 5,435,000 4,737,000 4,480,000 4,111,000 Total Operating Income as Reported 180,275,000 161.326,000 147,966,000 137,096,000 124,914,000 Total Expenses 180,275,000 161,326,000 147,966,000 137,096,000 124,914,000 Total Expenses 4,726,000 4,002,000 3,659,000 3,134,000 Net Income from Continuing & Dis... 2,679,000 4,717,582 3,996,708 3,638,021 3,117,532 Normalized Income 2,682,360 46,000 89,000 126,000 75,000 50,000 Interest Income 170,000 160,000 Interest Expense 150,000 159,000 134,000 - 124,000 -71,000 -24,000 -84,000 -84,000 Net Interest Income 6,428,000 5,527,000 4,915,000 4,601,000 EBIT 4,173,000 EBITDA 8,155,000 162,352,000 144,939,000 132,886,000 123,152,000 Reconciled Cost of Revenue 111,882,000 1,727,000 1,645,000 1,492,000 1,437,000 1,370,000 Reconciled Depreciation Net Income from Continuing Oper. Total Unusual Items Excluding Goo. 4.726,000 4,002,000 3,659,000 3,134,000 2,679,000 11,000 7,000 27,000 -5,000 23,000 Total Unusual Items 11,000 7,000 27,000 -5,000 23,000 8.144,000 Normalized EBITDA 7,165,000 6,380,000 6,015,000 5,548,000 0 0 0 0 0 Tax Rate for Calcs Tax Effect of Unusual Items 2,582 1,708 6,021 - 1,640 6,532 Balance Sheet All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Learn more 8/31/2020 Breakdown 8/31/2019 8/31/2018 8/31/2017 55,556,000 45,400,000 40,830,000 > Total Assets 36,347,000 36,851,000 29,816,000 27.727,000 > Total Liabilities Net Minority Int... 25,268,000 18,705,000 15,584,000 13,103,000 > Total Equity Gross Minority Inte... 11,079,000 25,798,000 20,367,000 19,286,000 Total Capitalization 17,351,000 18,284,000 Common Stock Equity 15,243,000 12,799,000 10,778,000 Capital Lease Obligations 2,558,000 18,284,000 15,243,000 12,799,000 Net Tangible Assets 10,778,000 3,276,000 Working Capital 248,000 363,000 -178,000 25,893,000 Invested Capital 22,066,000 19,286,000 17,437,000 18,284,000 15,243,000 12,799,000 Tangible Book Value 10,778,000 10,167,000 6,823,000 6,487,000 Total Debt 6,659,000 432,000 2,113,000 Net Debt 441,255 Share issued 439,625 438,189 437,204 441,255 439,625 438,189 437,204 Ordinary Shares Number Cash Flow All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Learn more Breakdown TTM 8/31/2020 8/31/2019 8/31/2018 8/31/2017 10,260,000 8,861,000 6,356,000 5,774,000 6,726,000 > Operating Cash Flow -3,321,000 -3,891,000 > Investing Cash Flow -2,865,000 -2,947,000 -2,366,000 -7,687,000 -1,147,000 > Financing Cash Flow -1,147,000 -1,281,000 -3,218,000 10,078,000 12,277,000 8,384,000 6,055,000 4,546,000 > End Cash Position Income Tax Paid Supplemental Data Interest Paid Supplemental Data 1,461,000 1,052,000 1,187,000 1,204,000 1,185,000 151,000 124,000 141,000 143,000 131,000 -3,346,000 -2,810,000 -2.998,000 -2,969,000 -2,502,000 1,000 3,992,000 298,000 80,000 3,782,000 -1,355,000 Capital Expenditure Issuance of Debt Repayment of Debt Repurchase of Capital Stock Free Cash Flow -3,200,000 -89,000 -86,000 -2,436,000 -452,000 -196,000 -247,000 -328,000 -469,000 6,914,000 6,051,000 3,358,000 2,805,000 4,224,000

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

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

Pioneers Of A Profession Chartered Accountants To 1879

Authors: Jas. C. Stewart

1st Edition

0367532557, 9780367532550

More Books

Students also viewed these Accounting questions

Question

Tell me about the other language(s) you speak.

Answered: 1 week ago

Question

Explain demotion as an alternative to termination.

Answered: 1 week ago

Question

Discuss termination of employees at various levels.

Answered: 1 week ago

Question

Discuss the various approaches to disciplinary action.

Answered: 1 week ago