(Answered) Build in excelnbsphome depot amp lowes

Finance

Build in excel Home depot & Lowes - last 10 years starting - 2007

1) Common size balance sheet and income statement

2) Ratio analysis - key ratios ( Solvency, liquidity, debt ratio)

3) Fine the du point analysis

4) Which company would you invest in? Lowes or homedepo? and Why?

5) Assume in 2007 you invested 10 million in each company, if you made no real dividend every year and you had 10% ,20% , 30% cost of capital in a 10 year horizon. Take all dividend and add up (simple not compound). In the 10th year you wanna get out of investing, what is the pv?

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92281691
Price:- $25

Verified Expert

Priced at $50 Now at $25, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Wandering rv is evaluating a capital budgeting project that

Wandering RV is evaluating a capital budgeting project that is expected to generate $36,950 per year during its six-year lie. If its required rate of return is 10%, what is the value of the project?

Researchers at the university of pennsylvania school of

Researchers at the University of Pennsylvania School of Medicine have determined that children under 2 years old who sleep with the lights on have a 35% chance of becoming myopic before they are 16. Children who sleep in ...

Question - a 5 storey office block is in the market for r

Question - A 5 storey office block is in the market for R 50 000 000 (including transfer duties, administration and commission expenses). The following information is applicable: The office block consists of 5000 m2 lett ...

Steve has purchased a treasury bill with a 182-day maturity

Steve has purchased a Treasury bill with a 182-day maturity and a $10,000 par value for $9,645. Ninety-two days later, Steve sells the T-bill for $9,719. Determine Steve's expected annualized yield from this transaction.

Question - your firm is contemplating the purchase of a new

Question - Your firm is contemplating the purchase of a new $670,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $50,000 at the end of ...

Question - laine needs to save up 4000 in 4 years if she

Question - laine needs to save up $4000 in 4 years. If she can set aside $1000 today, what rate of return does she need on her account? Elaine needs to save up $4000 in 4 years. If she can set aisde $50 per month what ra ...

Question one 11 what is meant by each of each of the

Question one: 1.1. What is meant by each of each of the following statements? a. "The present value of the future cash flows expected from an investment project is R30,000,000". b. "The net present value (NPV) of an inve ...

Your firm needs a machine which costs 190000 and requires

Your firm needs a machine which costs $190,000, and requires $40,000 in maintenance for each year of its 7 year life. After 5 years, this machine will be replaced. The machine falls into the MACRS 7-year class life categ ...

Praful co ltd purchased the business on 142010 the company

Praful Co. Ltd., purchased the business on 1.4.2010. The company obtained the certificate of commencement on 31.7.2010. The following details are available as on 31.3.2011. a) Total sales up to 31.3.2011 Rs.15, 00,000. O ...

An all-equiry business has 175m shares outstanding selling

An all-equiry business has 175M shares outstanding selling for $20/share. Management believes interest rates are unreasonably low and decides to execute a leveraged recapitalization. It will raise $1B in debt and repurch ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert