Use an excel spreadsheet and the fv pv pmt functions to

Assignment Help Accounting Basics

Reference no: EM13481505

Use an Excel spreadsheet and the FV, PV, PMT functions to determine the amount of each of the following, R=the annual interest rate and T=number of years,. When there are multiple cash flows per year, the amount of the annuity shown below is the amount of each individual cash flow (not the total sach flow forthe year). Round to the nearest dollar.

a. Present the value of a 500 annuity when R= 11% compounded annually and T=18

b. Future value of a 2,400 annuity when R=5% compounded annually and T=25

c. Future value of a 950 annuity when R=12.8% compounded semiannually and T=15

d. The annual annuity payment that will provide 13,400in eight years when R=9% compounded annually.

e. Present value of a 10,000 annuity when R= 8% compounded quarterly and T=10

f. Future value of a 238 annuity when R=7% compounded annually and T=16

g. Present value of a 1,000 annuity when R=6 3/8% compounded annually and T=3

h. Present value of a 700 annuity when R=10% compounded semiannually and T=11

i. The semiannual annuity payment what will pay off, over six years, a 9,860 debt owned today if R=13%

j. Future value of a dollar when R=8% compounded annually and T=200

Reference no: EM13481505

Questions Cloud

Seldin company owns a royalty interest in an oil well what : seldin company owns a royalty interest in an oil well. the contract stipulates that seldin will receive royalty

Redo the companys income statement at the 5100-unit level : problem 1-18a cost behavior high-low method contribution format income statement lo3 lo4 lo5frankel ltd. a british

What i need you to do is to prepare a complete set of : bobbi brown has come to me and asked for my help. sherecently started up a new consulting practice and needs some

Chiks chickens has average accounts receivables of 5433 : chiks chickens has average accounts receivables of 5433. sales for the year were 8900.00. what is its average

Use an excel spreadsheet and the fv pv pmt functions to : use an excel spreadsheet and the fv pv pmt functions to determine the amount of each of the following rthe annual

What would the sustainable growth rate be if davis chilis : consider the following information davis chilis bagwell company return on equity roe 14.10 9.00 plowback ratio 0.34

Wexford plc manufactures high quality wooden toys : wexford plc manufactures highquality wooden toys. production variesfrom long runs of popular models to short runs of

Aperson somehow gets hold of an extraordinary rare bird : q1 a person buysand sells a number of vehicles in a tax year and makes asignificant amount of profit in the process.

Flagstaff co has actual sales for july and august and : flagstaff co. has actual sales for july and august and forecast sales for september october november and december as

User Account

All Pages