Can u help me how other digits solve (excel) like the recovery, recovery percentage and the balance Table 5.6 Payback PeriodYearYear 1Year 2Year 3Year 4Year 5InitialInvestment2,994,220Cashflows686,453635,224755,959916,583917,4841,061,831Recovery686,4531,321,6782,077,6372,994,2202,995,1214,056,952Balance2,307,7671,672,542916,583Recovery22.93%44.14%69.39%100%100.03%135.49%Payback period is computed to be approximately 3 years, 11 months, and 30 days;which is within the first five years of operations. By the end of year 5, the project will haverecovered 135.49% of the Initial Investment.

Meaning of Payback Period: The payback period is a financial metric used to evaluate the length of…

Answered: Year Year 1 Year 2 Year 3 Year 4 Year 5…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Exhibit A.9 Present Value of an Annuity of $1 Year 1/2% 1% 2% 4% 5% 6% 8% 10% 12% 14% 15% 16% 18% 20% 22% 24% 25% 30% 35% 40% 1 0.995 0.990 0.980 0.962 0.952 0.943 0.926 0.909 0.893 0.877 0.870 0.862 0.847 0.833 0.820 0.806 0.800 0.769 0.741 0.714 2 1.985 1.970 1.942 1.886 1.859 1.833 1.783 1.736 1.690 1.647 1.626 1.605 1.566 1.528 1.492 1.457 1.440 1.361 1.289 1.224 3 2.970 2.941 2.884 2.775 2.723 2.673 2.577 2.487 2.402 2.322 2.283 2.246 2.174 2.106 2.042 1.981 1.952 1.816 1.696 1.589 4 3.950 3.902 3.808 3.630 3.546 3.465 3.312 3.170 3.037 2.914 2.855 2.798 2.690 2.589 2.494 2.404 2.362 2.166 1.997 1.849 5 4.926 4.853 4.713 4.452 4.329 4.212 3.993 3.791 3.605 3.433 3.352 3.274 3.127 2.991 2.864 2.745 2.689 2.436 2.220 2.035 6 5.896 5.795 5.601 5.242 5.076 4.917 4.623 4.355 4.111 3.889 3.784 3.685 3.498 3.326 3.167 3.020 2.951 2.643 2.385 2.168 7 6.862 6.728 6.472 6.002 5.786 5.582 5.206 4.868 4.564 4.288 4.160 4.039 3.812 3.605 3.416 3.242 3.161 2.802 2.508 2.263…
TABLE 13.2 Present value of an annuity of $1 ½% 6% 7% 1% 0.9901 1.9704 2% 0.9804 3% 0.9709 4% 0.9615 0.9950 1.9851 1.9416 1.9135 1.8861 5% 0.9524 1.8594 2.7232 3.5459 4.3295 2.9702 2.9410 2.8839 2.7751 2.8286 3.7171 3.9505 3.9020 3.6299 4.9259 4.4518 3.8077 4.8534 4.7134 4.5797 5.7955 5.6014 6.7282 6.4720 5.8964 5.2421 6.8621 5.4172 6.2303 7.0197 6.0021 7.8230 7.6517 7.3255 8.7791 8.5660 7.7861 8.1622 8.9826 5.0757 5.7864 6.7327 6.4632 7.4353 7.1078 8.1109 7.7217 8.3064 8.8632 9.7304 9.4713 8.5302 10.6770 10.3676 9.7868 9.2526 8.7605 8% 0.9434 0.9346 0.9259 1.8334 1.8080 1.7833 2.6730 2.6243 2.5771 3.4651 3.3872 3.3121 4.2124 4.1002 3.9927 4.9173 4.7665 4.6229 5.5824 5.3893 5.2064 6.2098 5.9713 5.7466 6.8017 6.5152 6.2469 7.3601 7.0236 6.7101 7.8869 7.4987 7.1390 11.2551 10.5753 8.3838 7.9427 7.5361 12.1337 9.9856 8.8527 8.3576 7.9038 13.4887 13.0037 12.1062 11.2961 10.5631 9.8986 8.2442 14.4166 13.8650 12.8492 11.9379 11.1184 10.3796 9.7122 9.1079 8.5595 15.3399 14.7179 13.5777…
Grove Media plans to acquire production equipment for $845,000 that will be depreciated for tax purposes as follows: year 1, $329,000; year 2, $189,000; and in each of years 3 through 5, $109,000 per year. A 10 percent discount rate is appropriate for this asset, and the company's tax rate is 20 percent. Use Exhibit A.8 and Exhibit A.9. Required: a. Compute the present value of the tax shield resulting from depreciation. b. Compute the present value of the tax shield from depreciation assuming straight-line depreciation ($169,000 per year). Complete this question by entering your answers in the tabs below. Required A Required B Compute the present value of the tax shield resulting from depreciation. Note: Round PV factor to 3 decimal places. Present value of the tax shield
enters Will and Jane Sparks are establishing a college fund for their 1-year-old daughter, Jennifer. They want to save enough now to pay college tuition at the time she college (17 years from now). If her tuition is projected to be $40,000 for a two-year degree, what annual sinking fund payment should they establish if the annual interest is 8%? Click the icon to view the table. The annual sinking fund payment is S. (Round to the nearest cent as needed.)
Appendix 9.1 – Period 7 at 10%Present value of $1 received in n periods= 0.5132 Appendix 9.2- Period 4 at 14% Present value of an annuity of $1 per period = 4.8684
Shuttle Company issued $1,000,000, three-year, 10 percent bonds on January 1, year 1. The bond interest is paid each December 31, the end of the company's fiscal year. The bond was sold to yield 9 percent. Use Table 9C.1, Table 9C.2. (Round time value factor to 4 decimal places.) Required: 1. Complete a bond payment schedule. Use the effective-interest amortization method. (Make sure that the unamortized discount/premium equals to '0' and the Net Liability equals to face value of the bond in the last period. Interest expense in the last period should be calculated as Cash Interest (+) discount / (−) premium amortized. Round intermediate and final answers to the nearest whole dollar.) Date 1/1/year 1 12/31/year 1 12/31/year 2 12/31/year 3 Interest expense Bonds payable Interest payment Issuance of bonds Payment of bonds Bond Payment Schedule Interest Expense Cash Payment $ 100,000 100,000 100,000 Amortization of Premium 2. What amounts will be reported on the financial statements…
Bau Long-Haul, Incorporated, is considering the purchase of a tractor-trailer that would cost $358,263, would have a useful life of 7 years, and would have no salvage value. The tractor-trailer would be used in the company's hauling business, resulting in additional net cash inflows of $81,000 per year. The internal rate of return on the investment in the tractor-trailer is closest to (Ignore income taxes.): Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor(s) using the tables provided. 02 Multiple Choice 13% 12% 15% 9:25 a 4/25/2 here to search acer 近

Carter Company is considering a project with an initial investment of $600,500 that is expected to produce cash inflows of $131,000 for ten years. Carter's required rate of return is 16%. E (Click on the icon to view Present Value of $1 table.) (Click on the icon to view Present Value of Ordinary Annuity of $1 table.) 14. What is the NPV of the project? 15. What is the IRR of the project? Is this an acceptable project for Carter? 16. 14. What is the NPV of the project? (Enter the factor amount to three decimal places, X.XXX. Round the present value of the annuity to the nearest whole dollar. Use parentheses or a minus sign for a negative net present value.) Annuity PV Factor (i=16%, n=10) Net Cash Present Years Inflow Value 1- 10 Present value of annuity Investment Net present value
Question 3 (at home, to practice) The following banks all offer 20-year Certificates of Deposits* (CDs), but at the following, different, conditions: Bank A: Bank B: Bank C: Bank D: Bank E: 10 percent per year compounded annually 9.8 percent per year compounded semiannually 9.6 percent per year compounded quarterly 9.5 percent per year compounded monthly 9.4 percent per year compounded daily Francesca has inherited £150,000. She decides to invest the money in the 20-year Certificate of Deposit offered by Bank E. If, instead, Francesca had invested her money in the bank with the CD offering the best rate, how much more money would she have had after 20 years? First write down the formulae you need to use to do the calculations. Then, solve numerically using a calculator or Excel.
ST Unit 8 Quest (11U) + pQLSf8ziezOsWz6j9T7OGVQSHI-6ls9bQrlQevfkKxle-RtQ3Rlg/formResponse Question 6: How much was the amount of the original loan? Regular Payment Rate of Compound Interest per Year Compounding Period semi-annual $1575 every 6 months 5.4% $8445.09 $17076.01 a. b. $14 444.94 $24 143.61 a b C. d. Time 6 years
What semiannual sinking fund payment would be required to yield $45,000 nine years from now? The annual interest rate is 6% compounded semiannually. Click the icon to view the table. The sinking fund payment is S (Round to the nearest cent as needed.)
Payment $ 123 4,555 74,484 167,332 Years 13 8 5 9 Interest Rate (Annual) 13 % 8 10 1 Future Value (Payment made on last day of period) Future Value (Payment made on first day of period)

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

Year Year 1 Year 2 Year 3 Year 4 Year 5 Initial Investment 2,994,220 Cashflows 686,453 635,224 755,959 916,583 917,484 1,061,831 Recovery 686,453 1,321,678 2,077,637 2,994,220 2,995,121 4,056,952 Balance 2,307,767 1,672,542 916,583 Recovery 22.93% 44.14% 69.39% 100% 100.03% 135.49%