Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Read the Data Case and answer the questions 1 through 6 based on your textbook readings and Internet research. You will need to use the following link to complete your assignment and access NASD Bond...

1 answer below »

Read the Data Case and answer the questions 1 through 6 based on your textbook readings and Internet research.

You will need to use the following link to complete your assignment and access NASD Bond Info:http://finra-markets.morningstar.com/BondCenter/Default.jsp

You need to download balance sheet and income statement of Home Depot from :

http://finra-markets.morningstar.com/MarketData/CompanyInfo/detail.jsp?query=14:0P000002OY

Simply go to financials.

Attached file is a case.

Solve everything in Excel please, including written parts (at least 5 sentences per question )

screen-shot-2021-10-09-at-65829-pm-huf4ah0x.png sample-5jiwrbka-yiiqyjqg.xls
Answered 1 days After Oct 09, 2021

Solution

Tanmoy answered on Oct 10 2021
123 Votes
Income Statement
        Period Ending:    2020    2019    2018    2017
        Total Revenue    132110000    110225000    108203000    100904000
        Cost of Revenue    44853000    72653000    71043000    66548000
        Gross Profit    87257000    37572000    37160000    34356000
        Operating Expenses
        Research and Development    0    0    0    0
        Sales, General and Admin.    24447000    19740000    19513000    17864000
        Non-Recu
ing Items    0    0    0    0
        Other Operating Items    2128000    1989000    1870000    1811000
        Operating Income    18278000    15843000    15530000    14681000
        Add'l income/expense items    47000    73000    93000    74000
        Earnings Before Interest and Tax    18325000    15916000    15623000    14755000
        Interest Expense    1347000    1201000    1067000    1057000
        Earnings Before Tax    16978000    14715000    14556000    13698000
        Income Tax    4112000    3473000    3435000    5068000
        Minority Interest    0    0    0    0
        Equity Earnings/Loss Unconsolidated Subsidiary    0    0    0    0
        Net Income-Cont. Operations    12866000    11242000    11121000    8630000
        Net Income    12866000    11242000    11121000    8630000
        Net Income Applicable to Common Shareholders    12866000    11242000    11121000    8630000
Balance Sheet
        Period Ending:    2020    2019    2018    2017
        Cu
ent Assets
        Cash and Cash Equivalents    2133000    1778000    3595000    2538000
        Net Receivables    2106000    1936000    1952000    2029000
        Inventory    14531000    13925000    12748000    12549000
        Other Cu
ent Assets    1040000    890000    638000    608000
        Total Cu
ent Assets    19810000    18529000    18933000    17724000
        Fixed Assets    22770000    22375000    22075000    21914000
        Goodwill    2254000    2252000    2275000    2093000
        Intangible Assets    0    0    0    0
        Other Assets    807000    847000    1246000    1235000
        Defe
ed Asset Charges    0    0    0    0
        Total Assets    51236000    44003000    44529000    42966000
        Cu
ent...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File