ZuoTi.Pro
Question

Use a financial calculator or an Excel spreadsheet to estimate the IRR for the following investment:...

Use a financial calculator or an Excel spreadsheet to estimate the IRR for the following investment:
Investment Initial Investment Future Value End of Year
A $1,600 $2,217 6
B $11,000 $33,472 12
C $500 $3,675 20
D $3,500 $5,428 7
E $5,100 $21,719 20

The Yield for Investment A is 5.59% ( but I don't know how)

The Yield for investment B is __?

The Yield for investment C is __?

Etc.

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Calculate the IRR as follows RATE(6,,-1600,2217) Function Arguments RATE Nper 6 Pmt = number Pv 1600 다둘 = -1600 Fy 2217 2217Answers 1 Investment Initial investment Future value Year 2 A Rate $1,600.00$2,217.00 $11,000.00$33,472.00 $500.00$3,675.00 $3,500.00$5,428.00 $5,100.00 $21,719.00 6 5.59% 12 9.72% 201 10.49% 71 6.47% 201 7.51% Formulas 1 Investment Initial investment Future value Year Rate 2 A 1600 11000 500 3500 5100 2217 33472 3675 5428 21719 6 RATE(D2,,-B2,C2) 12 RATE(D3,,-B3,C3) 20 RATE(D4,,-B4,C4) 7 RATE(D5,,-B5,C5) 20 RATE(D6,,-B6,C6) 5 D

0 0
Add a comment
Know the answer?
Add Answer to:
Use a financial calculator or an Excel spreadsheet to estimate the IRR for the following investment:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Use a financial calculator or an Excel spreadsheet to estimate the IRR for the following investment...

    Use a financial calculator or an Excel spreadsheet to estimate the IRR for the following investment The yield for investment Ais %. (Round to two decimal places.) Data Table Year $2,314 Initial Future End of Investment Investment Value $1,600 $9,300 $17.800 $700 $4,110 $2,900 $4,256 $5,500 $20.996 (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.

  • Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...

    Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following investments: The yield for investment Ais %. (Round to two decimal places.) The yield for investment Bis %. (Round to two decimal places.) Data Table Investment A Initial Investment $5.700 $8,976 End of Year Income $1,679.53 $2,100.00 $1,679.53 $2,600.00 $1,679.53 $3,100.00 $1,679.53 $3,600.00 $1,679.53 $4,000.00 (Click on the icon located on the top right comer of the data table below in order to...

  • 1. Determine the IRR of the following. (Hint: If you use the financial calculator app, there...

    1. Determine the IRR of the following. (Hint: If you use the financial calculator app, there is an IRR and NPV calculator option). A) Define IRR. Provide an example of how companies may use it. B) An initial investment of $10,750 resulting in a free cash flow of $3,500 at the end of year 1, $2,000 at the end of year 2, and $7,000 at the end of year 3. C) An initial investment of $5,000 resulting in a SINGLE...

  • P4A.16 (similar to) Question Help Using a financial calculator or an Excel spreadsheet, calculate the following...

    P4A.16 (similar to) Question Help Using a financial calculator or an Excel spreadsheet, calculate the following a. The present value of $740 to be received 2 years from now, using a discount rate of 14%. b. The present value of the following end-of-year income streams, using a discount rate of 21% and assuming it is now the beginning of 2018 a. The present value of the future sum in part (a) is $ (Round to the nearest cent.) 0 Data...

  • P4A.16 (similar to) Question Help Using a financial calculator or an Excel spreadsheet, calculate the following...

    P4A.16 (similar to) Question Help Using a financial calculator or an Excel spreadsheet, calculate the following a. The present value of $620 to be received 2 years from now, using a discount rate of 11% b. The present value of the following end-of-year income streams, using a discount rate of 19% and assuming it is now the beginning of 2018 a. The present value of the future sum in part (a) is $ . (Round to the nearest cent.) ©...

  • Using a financial calculator or spreadsheet, calculate the following: a. The future value of a deposit...

    Using a financial calculator or spreadsheet, calculate the following: a. The future value of a deposit of $380 left in an account paying 8% annual interest for 15 years. b. The future value at the end of 9 years of an annual end-of-year deposit of $500 into an account paying 11% annual interest a. The future value, FV, on a deposit of $380 left in an account paying 8% annual interest for 15 years is $ 1205.42. (Round to the...

  • 1. undersatnd how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b)...

    1. undersatnd how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR (c) Develop problem-solving and critical thinking skills and make long-term investment decisions 1) Life Period of the Equipment = 4 years 2) New equipment cost $(200,000) 3) Equipment ship & install cost $(35,000) 4) Related start up cost $(5,000) 5) Inventory increase $25,000 6) Accounts Payable increase $5,000 7) Equip. salvage value before tax $15,000 8) Sales...

  • Due: November 4.2019 1. EXCEL Spreadsheet: a. You must use the FINANCIAL FUNCTIONS in EXCEL to...

    Due: November 4.2019 1. EXCEL Spreadsheet: a. You must use the FINANCIAL FUNCTIONS in EXCEL to calculate your answers b. All calculations must be done in Excel Do not calculate anything on your calculator and just enter the number into Excel (if you do this, you will not receive credit for this assignment). Do the calculation within the cell c. You must reference cells from your base case (Only input variables that change for each requirement.) d. Your spreadsheet should...

  • Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs...

    Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs (ie. N, PV, etc.) to get partial credit. 1. How much would you pay for the right to receive $12,000 at the end of 15 years if you can earn a 15% return on a real estate investment with similar risk? 2. What constant amount invested at the end of each year at a 10% annual interest rate will be worth $20,000 at the...

  • Practice with probability and statistics - Feel free to use a calculator (or spreadsheet) to add/divide/etc,...

    Practice with probability and statistics - Feel free to use a calculator (or spreadsheet) to add/divide/etc, but please don't use any built-in statistical functions. 2, 2, 2, 3, 3, 4, 4, 5, 6, 6, 7, 7,8,s A. What is the probability that an object chosen at random from this box has length 2 cm? B. What is the average length of the (L) (also called the expectation value of length) of the objects? C. What is the probability that an...

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