Reference no: EM13259145
Use an Excel spreadsheet and the FV, PV, and PMT functions to determine the amount of each of the following . R = theannual interest rate and t = the number number of years. When the reare multipule cash flows per year, the amount ofannutity shown below is the amount of each individual cash flow (not the total cash flow for the year). Round all answers to thenearest dollar.
a. Present value of a $500annuity when R = 11% compounded annually and t =18
b. Future value of a $2,400annuity when R = 5% compounded annually and t= 25
c. Future value of$950 annuity when R = 12.8% compounded semiannually andt = 15
d. The annual annuitypayment that will $13,400 in eight years when R = 9%compounded annually
e. Present value of a$10,000 annuity when R = 8% compounded quartely andt = 10
f. Future value of a$238 annuity when R = 7% compounded annually andt = 16
g. Present value of a$1,000 annuity when R = 6?% compounded annually andt = 3
h. Present value of $700annuity when R = 10% compounded semiannualy and t= 11
i. Thesemiannually annuity payment that will pay off, over six years, a$9,860 debt owed today if R = 13%
j. Future valueof a $1 annuity when R = 8% compounded annually andt = 200
|
Determine the similarities that exist between method
: Determine the similarities that exist between Method, Starbucks, and Walmart. Discuss the similarities you see with companies that promote using.
|
|
What is the difference between gdp and ni
: What is the difference between GDP and NI? How has NI changed since 2008? What caused these changes?
|
|
Total amount of property-plant and equipment
: The following selected account balances appear on the December 31, 2010 balance sheet of Chen Co.
|
|
Compute the final volume and temperature
: a sample of 1.0 mole of a perfect gas with cp= 20.8 JK -1 is initially at 3.25 atm and 310 k. It undergoes reversible adiabatic expansion until its pressure reaches 2.50 atm. calculate the final volume and temperature and the work done
|
|
Determine the amount using fv-pv and pmt functions
: Use an Excel spreadsheet and the FV, PV, and PMT functions to determine the amount of each of the following . R = theannual interest rate and t = the number number of years.
|
|
What is acceleration of electron in uniform electric field
: (a) What is the acceleration of an electron in a uniform electric field of 1.0x106 N/C (b) How long would it take for the electron, starting from rest, to attain one-tenth the speed of light. Assume that Newtonian mechanics holds.
|
|
What will be the value of the investment in two years
: You identify a bank CD that pays an interest rate of 0.0500 with the interest being paid quarterly. What will be the value of the investment in two years?
|
|
Explain what is the partial pressure of ammonia
: 15.00 g of solid ammonium hydrogen sulfide is introduced into a 500.-mL flask at 25°C, the flask is sealed, and the system is allowed to reach equilibrium. What is the partial pressure of ammonia in this flask if Kp = 0.108 at 25°C for
|
|
Net income of dinkel company
: The following items are taken from the financial statements of Dinkel Company for the year ending December 31, 2010:
|