,Present and Future Values of Single Cash Flows for Different PeriodsFind the following values, using the equations, and then work the problems using a financial calculator to check your answers. Disregard rounding differences. (Hint: If you are using afinancial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" thevariable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d,and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent.a. An initial $500 compounded for 1 year at 7%.$b. An initial $500 compounded for 2 years at 7%.$c. The present value of $500 due in 1 year at a discount rate of 7%.$d. The present value of $500 due in 2 years at a discount rate of 7%.$Check My Work

To solve these problems, we will use the formulas for future value (FV) and present value (PV) of a…

Answered: , Present and Future Values of Single…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 6R: Reset the Data Section of the CAPBUD2 worksheet to the original values. In requirement 4, you...

See similar textbooks

Similar questions

Present and Future Values of Single Cash Flows for Different Periods Find the following values, using the equations, and then work the problems using a financial calculator to check your answers. Disregard rounding differences. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $600 compounded for 1 year at 6%. $   An initial $600 compounded for 2 years at 6%. $   The present value of $600 due in 1 year at a discount rate of 6%. $   The present value of $600…
Find the following values, using the equations, and then work the problems using a financial calculator to check your answers. Disregard rounding differences. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $800 compounded for 1 year at 5.5%. $   An initial $800 compounded for 2 years at 5.5%. $   The present value of $800 due in 1 year at a discount rate of 5.5%. $   The present value of $800 due in 2 years at a discount rate of 5.5%. $
nd the present value of the following ordinary annuities. (Notes: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in many situations, to see how changes in input variables affect the output variable. Also, note that you can leave values in the TVM register, switch to Begin Mode, press PV, and find the PV of the annuity due.) Do not round intermediate calculations. Round your answers to the nearest cent. $600 per year for 10 years at 12%. $    $300 per year for 5 years at 6%. $    $600 per year for 5 years at 0%. $    Now rework parts a, b, and c assuming that payments are made at the beginning of each year; that is, they are annuities due. Present value of $600…
Garage, Inc., has identified the following two mutually exclusive projects. a. What is the IRR for each project? b. If the required return is 11 percent, what is the NPV for each project? c. What is the crossover rate between these two projects? Year 0 Year 1 Year 2 Year 3 Year 4 Required return SSSSS A (43,500) 21,400 18,500 13,800 7,600 $ ESSASALA $ $ $ $ B (43,500) 6,400 14,700 22,800 25,200 11% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question.
Present and Future Values of Single Cash Flows for Different Interest Rates Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $700 compounded for 10 years at 6%. $ An initial $700 compounded for 10 years at 12%. $ The present value of $700 due in 10 years at a 6% discount rate. $ The present value of $700 due in 10 years at a 12% discount rate. $
Subject:- Accouning
Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. a. An initial $500 compounded for 10 years at 3%. $ b. An initial $500 compounded for 10 years at 6%. S C. The present value of $500 due in 10 years at a 3% discount rate. S d. The present value of $500 due in 10 years at a 6% discount rate. $
The following set of cash flows has two internal rates of return. Calculate the 2nd IRR for the cash flows. (Enter percentages as decimals and round to 4 decimals). Hint: you will need to use a guess in the Excel function. Time 0 1 2 3 4 CF 8125 -17000 8000 -7500 9000
3.
None
Can you please help me answer the term. No calculation needed. I need to review for my midterms. Thank you
Reset the Data Section of the CAPBUD2 worksheet to the original values. In requirement 4, you assessed the sensitivity of the investment’s internal rate of return to changes in some of the input data. This was done in a trial-and-error fashion. Click the Chart sheet tab. Presented on the screen is a graphical analysis of the sensitivity of the internal rate of return to changes in annual cash flows. To demonstrate the usefulness of such a chart, note the ease with which you are able to answer the following questions that might be of interest to the owner: What annual cash flow (approximately) is required to: earn 0% rate of return? _______________ earn 10% rate of return? _______________ earn over 20% rate of return? _______________ Approximately, how much is the rate of return reduced for each drop of $10,000 annual cash flow? When the assignment is complete, close the file without saving it again. Worksheet. The CAPBUD2 worksheet handles only cash inflows that are even in amount each year. Many capital projects generate uneven cash inflows. Suppose that the new store had expected cash earnings of $80,000 per year for the first two years, $140,000 for the next four years, and $220,000 for the last four years. The new store will generate the same total cash return ($1,600,000) as in the original problem, but the timing of the cash flows is different. Alter the CAPBUD2 worksheet so that the NPV and IRR calculations can be made whether there are even or uneven cash flows. When done, preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as CAPBUDT. Hint: One suggestion is to label column F in the scratch pad as Uneven cash flows. Enter the uneven cash flows for each year. Modify FORMULA3 to include these cash flows. Modify the formulas in the range E30 to E39 to include the new data. Then set cell E10 (estimated Annual Net Cash Inflow) to zero. When you have even cash flows, use cell E10 and set column F in the scratch pad to zeros. If you have uneven cash flows, set cell E10 to zero and fill in column F in the scratch pad. Note that this solution causes garbage to come out in cells E15 and E16 because those formulas were not altered. Check figure for uneven cash flows: NPV (cell E17), $68,674. Chart. Using the CAPBUD2 file, develop a chart just like the one used in requirement 6 to show the sensitivity of net present value to changes in cost of the investment amount from $440,000 to $500,000 (use $10,000 increments). Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as CAPBUD2. Print the chart.

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

SEE MORE TEXTBOOKS