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. $

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. $

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 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 3%. $ An initial $700 compounded for 10 years at 6%. $ The present value of $700 due in 10 years at a 3% discount rate. $ The present value of $700 due in 10 years at a 6% discount rate. $
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…
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…
Find 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. $400 per year for 10 years at 10%. $ $200 per year for 5 years at 5%. $ $400 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 $400 per…
Find 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. 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 $800 per year for 10 years at 14%: $ Present value of $400 per year for 5 years at 7%: $ Present value of $800 per year for 5…
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. $
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 $400 compounded for 10 years at 5%. An initial $400 compounded for 10 years at 10%. The present value of $400 due in 10 years at a 5% discount rate. The present value of $400 due in 10 years at a 10% discount rate.
Present Value of an Annuity Find 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 10%. $ $300 per year for 5 years at 5%. $ $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…
Present Value of an Annuity Find 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. $800 per year for 10 years at 8%. $ $400 per year for 5 years at 4%. $ $800 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…
Present Value of an Annuity Find 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. $800 per year for 10 years at 14%. $ $400 per year for 5 years at 7%. $
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.
Please see attched problem problems should be solved by using a financial calculator or MS excel spreadsheet. Accordingly, you must show the values of all relevant time valu of money variables