1) (2 points) Complete the table by computing the present values (PVS) of $20,000 received in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1) (2 points) Complete the table by computing the present values (PVS) of $20,000 received in the given years from 0 to 50 when the interest rate is 5% when the interest rate is 10% when the interest rate is 20% using the PV formula (not the PV Excel function) and absolute or/and relative references (e.g., $B$2, $B2, B$2, or B2) in the most efficient way (show your formulas using the formulatext Excel function). 2) (1.5 points) Draw a scatter plot of the PVs of $20,000 using the table in 1). X-values: Years ● ● Y-values: PVS (three Y-series: PVs at 5%, PVs at 10% and PVs at 20%) Add the chart title, "Scatter chart of PVs of $20,000 at various interest rates." ● 3) (1.5 points) Draw a line chart of the PVs of $20,000 using the table in 1). X-values: Years ● ● Y-values: PVs (three Y-series: PVs at 5%, PVs at 10% and PVs at 20%) Add the chart title, "Line chart of PVs of $20,000 at various interest rates." 4) (1 point) Choose the correct answer in the following statements: ● ● When the interest rate increases, the PV of $20,000 (increases, decreases). The PVs of $20,000 are (positively, negatively) associated with the interest rates (r). 1 FV 2 3 1) 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A Year 0 1 1.5 3 5.5 7.5 10 13 17 20 25 32 40 46 50 $ B 20,000 5% C PV 10% D 20% E 5% 25 26 4) (1 point) Choose a correct answer in the following statements 27 When the interest rate increases, the PV of $10,000 (increases, decreases). 28 *The PVs of $10,000 are (positively, negatively) associated with the interest rates (r). formulatext 10% G 20% H 1) (2 points) Complete the table by computing the present values (PVS) of $20,000 received in the given years from 0 to 50 when the interest rate is 5% when the interest rate is 10% when the interest rate is 20% using the PV formula (not the PV Excel function) and absolute or/and relative references (e.g., $B$2, $B2, B$2, or B2) in the most efficient way (show your formulas using the formulatext Excel function). 2) (1.5 points) Draw a scatter plot of the PVs of $20,000 using the table in 1). X-values: Years ● ● Y-values: PVS (three Y-series: PVs at 5%, PVs at 10% and PVs at 20%) Add the chart title, "Scatter chart of PVs of $20,000 at various interest rates." ● 3) (1.5 points) Draw a line chart of the PVs of $20,000 using the table in 1). X-values: Years ● ● Y-values: PVs (three Y-series: PVs at 5%, PVs at 10% and PVs at 20%) Add the chart title, "Line chart of PVs of $20,000 at various interest rates." 4) (1 point) Choose the correct answer in the following statements: ● ● When the interest rate increases, the PV of $20,000 (increases, decreases). The PVs of $20,000 are (positively, negatively) associated with the interest rates (r). 1 FV 2 3 1) 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A Year 0 1 1.5 3 5.5 7.5 10 13 17 20 25 32 40 46 50 $ B 20,000 5% C PV 10% D 20% E 5% 25 26 4) (1 point) Choose a correct answer in the following statements 27 When the interest rate increases, the PV of $10,000 (increases, decreases). 28 *The PVs of $10,000 are (positively, negatively) associated with the interest rates (r). formulatext 10% G 20% H
Expert Answer:
Answer rating: 100% (QA)
Based on the given images to complete the table youll need to calculate the present value PV of rece... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
1. a) Fill in the missing numbers in the inventory schedule using the weighted-average cost inventory valuation method. This company uses the perpetual inventory system. Do not enter dollar signs or...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Water flows in a cylindrical, horizontal pipe. As the pipe narrows to half its initial diameter, the pressure in the pipe changes. (a) Is the pressure in the narrow region greater than, less than, or...
-
If the 10 K ohms resistor in the network shown absorbs 2.5 mW, find Vs. Vs 10 k
-
How might you distinguish between -D-glucopyranose (i.e., D-glucose) and methyl -D-glucopyranoside?
-
The Blending Department of Battle Company has the following cost and production data for the month of April. Units transferred out totaled 8,000. Ending work in process was 1,000 units that are 100%...
-
Your client is a company that owns a shopping center with 30 store tenants. All leases with the store tenants provide for a fixed rent plus a percentage of sales, net of sales taxes, in excess of a...
-
16. You purchase an item in India for 500 Re. How much did you pay in American dollars?
-
How would you detect the distribution of the constituents of human hair with a diameter of about 80 m using methods of vibrational spectroscopy? Describe the use of at least two different approaches;...
-
29. (14 points) Prepare in general journal form the entries required for each of the following selected transactions of Medical Hospital Foundation, a not-for-profit hospital for the current year. a)...
-
In preparing a company's statement of cash flows using the indirect method, the following information is available: Net income Accounts payable decreased by Accounts receivable increased by...
-
Congratulations! You've graduated and you have two excellent job offers. The first offer is in Buffalo, NY where the CPI is 1 8 0 and it has a salary of $ 6 5 , 0 0 0 a year. The second offer is in...
-
An investor acquires 100 A shares worth $550 each and 75 B shares at a unit price of $600. The expected returns and risks (standard deviation) of actions A and B are respectively of the order of 12%...
-
If a scope limitation is material, auditors cannot state a conclusion without evidence to support the conclusion auditors should state a conclusion even without evidence to support the conclusion it...
-
A primary benefit of a good bookkeeping systems is the compilation of financial statements including the OA) Angel Investment report. O B) Equity Investment report. OC) Income Statement. OD) Accrual...
-
Answer plz . C&H Ski Club recently borrowed money and agreed to pay it back with a series of six annual payments of $19,000 each. C&H subsequently borrows more money and agrees to pay it b...
-
You continue to work in the corporate office for a nationwide convenience store franchise that operates nearly 10,000 stores. The per- store daily customer count (i.e., the mean number of customers...
-
Kathy Kennedy (age 44) is a single taxpayer and she lives at 212 North Pine Way, Payson, AZ 85541. Her Social Security number is 467-98-9784. Kathy's earnings and income tax withholding as the...
-
Dr. Ivan I. Incisor and his wife Irene are married and file a joint return for 2012. Ivan's Social Security number is 477-34-4321 and he is 48 years old. Irene I. Incisor's Social Security number is...
-
Patty Bayan is a single taxpayer living at 543 Space Drive, Houston, TX 77099. Her Social Security number is 466-33-1234. For 2012, Patty has no dependents, and her W-2 from her job at a local...
-
Why is the timetable for a first issue for a company issuing a high yield bond much longer than for the issue of a standard bond?
-
Describe two different methods used for calculating the value of a subscription right.
-
Which party is the bank which places the shares working for the issuer or the investor subscribing the shares?
Study smarter with the SolutionInn App