Sale!

Solution Manual for Financial Analysis with Microsoft Excel, 6th Edition

Original price was: $35.00.Current price is: $26.50.

SKU: jkwpm374015 Category: Solution Manual

Description

This is completed downloadable of Solution Manual for Financial Analysis with Microsoft Excel, 6th Edition

Product Details:

ISBN-10 ‏ : ‎ 1111826242
ISBN-13 ‏ : ‎ 978-1111826246
Author: Timothy R. Mayes, Todd M. Shank

Now readers can master their Excel 2010 skills while establishing a strong understanding of contemporary corporate finance. Mayes/Shank’s FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2010, 6E shows today’s reader how to tap into some of Excel 2010’s most powerful tools to solve real financial problems. The book’s solid content addresses today’s most important corporate finance topics, including financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. This edition now covers Excel tables, pivot tables and pivot charts and other areas that have become increasingly important to today’s employers. The book’s reader-friendly, self-directed learning approach and numerous study tools help readers build upon basic skills for the Excel 2010 proficiency and the solid finance knowledge business professionals need for success.

Table of Content:

Step 1 of 14

Capital budgeting techniques helps to take decision as whether a project should be accepted or rejected by the firm. There are many capital budgeting techniques like Net Present Value, Internal Rate of return, Profitability Index and many more.

Step 2 of 14

The Initial cost for Project A and B is $75,000 and projected cash flows for both the projects for five years is given.

Step 3 of 14

(a)

The Weighted Average Cost of Capital (WACC) is 10%.

Calculate the payback period for Project A as follows:

The initial outlay of the project is $75,000. This will be recovered in year 3 plus fractions of fourth year. Payback period is as follows:

Therefore, the payback period for Project A is .

Step 4 of 14

Calculate the payback period for Project B as follows:

The initial outlay of the project is $75,000. This will be recovered in year 2 plus fractions of third year. Payback period is as follows:

Therefore, the payback period for Project B is .

Step 5 of 14

Calculate the discounted payback period for Project A as follows:

Step 6 of 14

Formulas for above values are as follows:

The initial outlay of the project is $75,000. This will be recovered in year 4 plus fractions of fifth year. Payback period is as follows:

Therefore, the discounted payback period for Project A is.

Step 7 of 14

Calculate the discounted payback period for Project B as follows:

Formulas for above values are as follows:

The initial outlay of the project is $75,000. This will be recovered in year 3 plus fractions of fourth year. Payback period is as follows:

Therefore, the discounted payback period for Project B is.

Step 8 of 14

Calculate the Net Present Value (NPV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR) and Profitability Index (PI) as follows: