(Answered) Part 1please solve both the questions using ms

Finance

PART 1

Please solve both the questions using MS EXCEL

Question 1

A firm whose cost of capital is 10% is considering two mutually exclusive projects X and Y, the details of which are:

Year Project X Project Y

Cost 0 Rs. 70,000 Rs. 70,000

Cash Inflows 1 Rs. 10,000 Rs. 50,000

2 Rs. 20,000 Rs. 40,000

3 Rs. 30,000 Rs. 20,000

4 Rs. 45,000 Rs. 10,000

5 Rs. 60,000 Rs. 10,000

Compute the Net Present Value at 10%, Profitability Index, and Internal Rate of Return of the two projects.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M91536322
Price:- $12

Verified Expert

Priced at $24 Now at $12, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Question - boundaries a chain of retail stores sells books

Question - Boundaries, a chain of retail stores, sells books and music CDs. Condensed monthly income data are presented in the following table for November 20x4. Downtown Store Mall Store Total Sales $240,000 $360,000 $6 ...

1 pet delight specializes in gourmet pet treatsnbspsales

1. Pet Delight specializes in gourmet pet treats. Sales estimates in millions for the next two quarters are $500 for 1Q and $600 for 2Q. All sales are made on credit. The company's beginning accounts receivable balance i ...

Principals of financial markets group assignment -in groups

Principals of Financial Markets Group Assignment - In groups of 3-4, students should choose firstly an industry and secondly two (2) ASX listed companies in this same industry upon which to undertake a fundamental analys ...

A firm has common stock of 15300 total liabilities of 8400

A firm has common stock of $15,300, total liabilities of $8,400, current assets of $5,900, and fixed assets of $21,200. What is the amount of the shareholders' equity?

You borrow 165000 to buy a house the mortgage rate is 40

You borrow $165,000 to buy a house. The mortgage rate is 4.0 percent and the loan period is 30 years. Payments are made monthly. If you pay the mortgage according to the loan agreement, how much total interest will you p ...

Evaluate the following fund using single-index modelfund

Evaluate the following fund using single-index model: Fund 1: Alpha (a): 1.1 Beta (B): 1.9 Variance (e): 100 Market risk expected return is 8%, and an expected standard deviation =12.25% or market variance 150. Using the ...

Question -1 how did the liability of newness affect justin

Question - 1. How did the "liability of newness" affect Justin Gold as he attempted to formally launch his entrepreneurial venture? 2. What key employees did Gold recruit to be members of his new-venture team? 3. What cr ...

What would be examples of valid selection methods used by

What would be examples of valid selection methods used by the human resource department to ensure selecting the appropriate candidate for a job.

A credit unions rate-climber gic pays rates of 2 6 and 8

A credit union's Rate-Climber GIC pays rates of 2%, 6%, and 8% compounded semiannually in successive years of a three-year term. How much interest will be earned in the second year, if $18,000 is invested in this GIC?

Find the modified internal rate of return mirr the annual

Find the modified internal rate of return (MIRR) The annual rate is 8.24%. Initial outlay is $356,800. Year 1: $163,100 Year 2: $173,100 Year 3: $181,300 Year 4: $175,700 Year 5: $161,400

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