User Account

All Pages

Determine the amount using fv-pv and pmt functions

Assignment Help Accounting Basics
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

Reference no: EM13259145

Questions Cloud

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:

Reviews

Write a Review

Accounting Basics Questions & Answers

  Return on its investment problem

Jill Morris is presently leasing a small business computer from Eller Office Equipment Company. The lease requires 10 annual payments of $4,000 at the end of each year and provides the lessor (Eller) with an 8% return on its investment. You may us..

  How does modified accrual basis of accounting differ acrual

What are the three sections of a comprehensive annual financial report (CAFR) What information is contained in each section How do the minimum requirements for general purpose external financial reporting related in scope to the CAFR

  Determine what the ethical considerations in situation

Search the Internet for at least four (4) stories about major charitable contributions by individuals, including Bill Gates, Warren Buffett, Steve Jobs, and at least one (1) other individual. Be mindful that you are not researching foundations, su..

  Amount of under or overallocation of manufacturing overhead

Compute the amount of under- or overallocation of manufacturing overhead. Is the amount material? Prepare a journal entry to dispose of this amount.

  Weighted-average unit contribution margin

Konerko Company sells two types of computer chips. The sales mix is 30% (Q-Chip) and 70% (Q-Chip Plus). Q-Chip has variable costs per unit of $30 and a selling price of $50. Q-Chip Plus has variable costs per unit of $35 and a selling price of $65..

  Consolidated income statement problem

On December 31, 20X8, Parent Company purchased one-half of the outstanding bonds for $96,000. Both companies use the straight-line method of amortization. How much interest expense will appear on the December 31, 20X8, consolidated income statemen..

  Financial statements for fiscal year

In the financial statements for its fiscal year ended December 31, Year 2, Investor should report a realized loss on disposal of the Investee Co. shares equal to:

  Accountants produce financial statements

During an entity's lifetime, accountants produce financial statements at arbitrary moments in time in accordance with which basic accounting concept?

  What is the annual net cost of a monthly fee

What is the annual net cost of a monthly fee of $5, check processing fee of $.25, average 19 checks per month.

  Cost versus usage percentages be assessed and analyzed

How should cost versus usage percentages be assessed and Analyzed? This area will need to address actual costs compared to edible portion costs. It should also include how waste affects costs. 100-150 words

  Why may net cash flow from operating activities

Revenue represents the benefit a company experiences from operating its business. In accounting terms, revenues are increases in assets or decreases in liabilities resulting from business operations. Accrual accounting requires companies to recogn..

  Decision to record the two million dollar loss

If the hurricane hits our business, we can reasonably be assuredthat we will incur a $2 million loss. We want to finish closing March's books. Should we record the $2million loss? Why or why not?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd