Use an excel spreadsheet and the fv pv pmt functions to, Ask an Expert

Accounting

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

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M9796681

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question -what are the factors that affect the decision to

Question - What are the factors that affect the decision to prosecute an entity? How can computers and technology help in investigating a fraud? What kinds of challenges can the involvement of technology present to a cas ...

Question - dollars for dozers entity dde has a bulldozer it

Question - Dollars for Dozers Entity (DDE) has a bulldozer it acquired 3 years ago. DDE has decided to sell the dozer in its principle market located in Tennessee. DDE has decided that the dozer needs to recondition its ...

Question - recent financial statements of general mills inc

Question - Recent financial statements of General Mills, Inc. report net sales of $12,442,000,000. Accounts receivable are $912,000,000 at the beginning of the year and $953,000,000 at the end of the year. Compute Genera ...

Assignment 2 discussion questionthe finance department of a

Assignment 2: Discussion Question The finance department of a large corporation has evaluated a possible capital project using the NPV method, the Payback Method, and the IRR method. The analysts are puzzled, since the N ...

Question - richard and pauline jackson have a small mowing

Question - Richard and Pauline Jackson have a small mowing and gardening business in which they have been working for the last eight years. As it is only the two of them in the business they operate as a partnership. The ...

Question - restricted stockon december 31 2014 ying

Question - Restricted Stock On December 31, 2014, Ying Corporation granted 5,000 shares of its $1 par value common stock to certain of its key employees. The shares are restricted until 2 years of employment is completed ...

Question - the records of riverbeds boutique report the

Question - The records of Riverbed's Boutique report the following data for the month of April. Sales revenue$100,100 Purchases (at cost) $47,400 Sales returns 1,900 Purchases (at sales price) 95,300 Markups 9,500 Purcha ...

Question - alison ltd after negotiations with darley ltd

Question - Alison Ltd, after negotiations with Darley Ltd, acquired all the assets (except Cash at Bank and Shares in Alison Ltd) and all liabilities of Darley Ltd. Alison Ltd issued 300,000 fully paid $1 shares and paid ...

Question - consider the following account starting balances

Question - Consider the following account starting balances and transactions involving these accounts. Use T-accounts to record the starting balances and the offsetting entries for the transactions. The starting balance ...

Company accounting questions -a opperman ltd owns all the

COMPANY ACCOUNTING QUESTIONS - (A) Opperman Ltd owns all the share capital of Jewel Ltd. During the year ended 30 June 2018, Opperman Ltd paid a dividend of $20 000, and Jewel Ltd paid and declared dividends of $10 000 a ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert