Question

P5-60 Number of years to provide a given return In each of the following cases, determine the number of years that the given

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The number of years the annuity must continue is found using the NPER function in excel. In excel, choose formulas, financial and select NPER function.

File fx Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Σ ? A la e Define Name - Trace Pre

Bus Book1 - Excel File fx Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do * ? le e Define

File - Trace Preceden fx Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do ? Define Name la

File fx Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do * ? - Trace Pre А le @ Define Name

File fx Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do ? А le @ Define Name Trace Precede

Add a comment
Know the answer?
Add Answer to:
P5-60 Number of years to provide a given return In each of the following cases, determine...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please show works P5-60 Number of years to provide a given return In each of the...

    Please show works P5-60 Number of years to provide a given return In each of the following cases, determine the number of years that the given ordinary annuity cash flows must continue to provide the desired rate of return given the cost of the annuity. Case Desired rate of return 11% 15 А B C Cost of annuity $ 1,000 150,000 80,000 600 17,000 Annuity payment $ 250 30,000 10,000 275 3,500 10 9 D E 6

  • we P5-58 Number of years to equal future amount For each of the following cases, determine...

    we P5-58 Number of years to equal future amount For each of the following cases, determine il deposit to grow to equal amount at the given interest rate. CD O ears it will take fo . 0 0 OL Future amount Interest rate Solo O O A la O O O O

  • P5-18 Calculating deposit needed You put $10,000 in al 3 years, you make another deposit into...

    P5-18 Calculating deposit needed You put $10,000 in al 3 years, you make another deposit into the same account. Four 7 years after your original $10,000 deposit), the account balanc was the amount of the deposit at the end of year 3? t. Four years later th e is $20,000, w Fürure value of an annuity For each case in the accompanying table, answer the Ps-19 questions that follow. Case Annuity payment Interest rate Annuity length (years) 5 2,500 500...

  • Given the following cash flows for two mutually exclusive projects, and a required rate of return...

    Given the following cash flows for two mutually exclusive projects, and a required rate of return of 12%, what is the EAA for Project A? Year 0 1 Project A -300,000 150,000 150,000 80,000 80,000 2 Project B -300,000 70,000 70,000 120,000 120,000 120,000 60,000 5 6 O 69,055 0 61,292 O 20.179 O 19,086 0 78,468 By purchasing training software for $7,000, you can eliminate other training costs of $3,400 each year for the next 10 years. What is...

  • Payback, Accounting Rate of Return, Present Value, Net Present Value, Internal Rate of Return For discount...

    Payback, Accounting Rate of Return, Present Value, Net Present Value, Internal Rate of Return For discount factors use Exhibit 12B.1 and Exhibit 12B.2 All scenarios are independent of all other scenarios. Assume that all cash flows are after-tax cash flows a. Kambry Day is considering investing in one of the following two projects. Either project will require an investment of $20,000. The expected cash flows for the two projects follow. Assume that each project is depreciable. ProjectA 6,000 8,000 10,000...

  • Cash Payback period for a Service Company Jane's Clothing Inc. is evaluating two capital investment proposals...

    Cash Payback period for a Service Company Jane's Clothing Inc. is evaluating two capital investment proposals for a retail outlet, each requiring an investment of $150,000 and each with an eight-year life and expected total net cash flows of $240,000. Location 1 is expected to provide equal annual net cash flows of $30,000, and Location 2 is expected to have the following unequal annual net cash flows: Year 1 $59,000 Year 2 44,000 29,000 Year 3 Year 4 18,000 Year...

  • determine the irr of each of these projects. which project should be accepted To: The New...

    determine the irr of each of these projects. which project should be accepted To: The New Financial Analyst From: Mr. R. Harrison, CEO, Park Products Re: Capital-Budgeting Analysis Provide an evaluation of four proposed projects, all with 5-year expected lives and identical initial outlays of $110,000. All of these projects involve additions to Park's highly successful Avalon product line, and as a result, the required rate of return on all projects has been established at 10 percent. The expected free...

  • Please help me solve 4-8 Use the following table to answer questions 1 – 6. The...

    Please help me solve 4-8 Use the following table to answer questions 1 – 6. The wacc is 10% for all projects in this table. Year Project A -1,000 1,000 Project B -1,000 300 400 500 600 Project C -1,000 550 450 350 250 Project D -1,000 600 800 1. Compute the Net Present Value (NPV), Internal Rate of Return (IRR), Profitability Index (PI), and Payback Period (PB) for each project: Project A Project B Project C Project D WACC...

  • You enter in a BES scheme (Individual Annuity Insurance or Private Pension System). You agree to...

    You enter in a BES scheme (Individual Annuity Insurance or Private Pension System). You agree to pay 200 TL per month. You expect a return of 1% per month. What will be your expected fund size at the end of year 5? At the end of the 1st year you find out that your investments are worth 2,480 TL. What was the rate of return on your first year? At the end of year 3 your investments are worth 8,200...

  • Tab, Inc., Income Statements for Fiscal Years 2003, 2004, and 2005 Amount (in millions of dollars)...

    Tab, Inc., Income Statements for Fiscal Years 2003, 2004, and 2005 Amount (in millions of dollars) 2005 2004 2003 Revenues $25,000 20,000 $22,000 18,000 $21,000 17,000 Cost of sales $4,000 Gross profit Selling, general, and administrative expenses $5,000 500 $4,000 800 500 Operating income Interest and other nonoperating expense $4,500 200 $3,500 250 $3,200 250 $2,950 Earnings before income taxes Income tax $4,300 1.410 $3,250 975 885 Net income $2,890 $2,275 $2,065 Tab, Inc., Balance Sheets as of End of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT