You have been depositing money into an account yearly based on the following investment amounts, rates and times, what is the value of that investment account at the end of that period? (Click here to see present value and future value tables) Amounts of Value at the End Investment Rate Times of the Period $7,000 20% 16 years 612,094.91 X $11,000 15% 9 years 184,644.26 X $15,000 12% 5 years 95,292.71 $36,000 10% 2 years 75,600.00

You have been depositing money into an account yearly based on the following investment amounts, rates and times, what is the value of that investment account at the end of that period? (Click here to see present value and future value tables) Amounts of Value at the End Investment Rate Times of the Period $7,000 20% 16 years 612,094.91 X $11,000 15% 9 years 184,644.26 X $15,000 12% 5 years 95,292.71 $36,000 10% 2 years 75,600.00

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 2R

See similar textbooks

Similar questions

Exploring Annuities with Microsoft Excel I. Objectives: To organize data and perform calculations using Microsoft Excel To find future values for an annuity To determine payment amounts for an annuity given a set goal To analyze the effect of time To research reasonable annuity rates and investment amounts for use in the above calculations II. Procedure: Sheet 1 - Future Value 1. Open a new Microsoft Excel (or Google Sheets) blank spreadsheet. 2. At the bottom of the page, it will show "Sheet 1". You can rename it "Future Value". a. Right click the "Sheet 1" tab and you will see an option to rename it. 3. Type "Payment Amount (P)" in cell A1. 4. Type "Rate (i)" in cell B1. 5. Type "Number of Payments per year (n)" in cell C1. 6. Type "Years (t)" in cell D1. Now the research.. You need to investigate reasonable annuity rates for our current market. You can choose a rate of your own using the information you find. Also, I want you to find out what investors suggest your payment amount…
Determine the future value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) Invested Amount i- n Future Value 1. $ 11,500 7% 15 23 $ 15,000 6% 14 $ 28,000 12% 14 4. S 48,000 8% 6
2. Use the worksheet tab Problem 2 A-FV Retirement and Problem 2 B -PV Invest K File 6 7 ñ Paste K11 16 17 18 Book1 - Excel Clipboard Home Insert Calibri X Dr- Ready B I U 89- Draw Page Layout Formulas Data Review View == 28 M =100- Font 2 Return Rate 3 Investment Duration in Years 4 Amount Invested Future Investment Value fx One-Time Investment Scena Return Rate 9Investment Duration in Years 10 Monthly Payroll Deduction 11 Company Match 12 Monthly Investment 13 Current Balance 14 Future Investment Value 15 Sheet1 11 A A A- Retirement Plan Scenario Sheet2 Accessibility: Investigate D O AI 19 9 Return Rate = 5.500% 13 7500 Alignment 4.500% 35 500 50% 750 $10,000.00 19 D O Search General - $ % 9 68 28 Number Automate Help Acrobat Conditional Formatting W Format as Table Cell Styles - Styles Goal seek Future Savings Value at $20,000 Future Savings Value at $25,000 Insert Delete Format - Cells G O dating FS Sensitivity Retirement plan Goal Seek Solution by changing Return Rate-Goal seek…
nnuity. Fill in the missing present values in the following table for an ordinary annuity: Future Value ate Data Table (Click on the following icon O in order to copy its contents into a spreadsheet) it Valuo $298 01 S3.396 92 S615 39 $2.459 07 6% 12% 2.5% 07% 18 0. 27 260 0. Print Done Check A
Create an Excel spreadsheet that calculates the internal rate of return for the following set of cashflows: Period 012345 Cashflow $1123.01 $100 $100 $100 $100 $ 1,100 Note your spreadsheet should calculate the present value of each of the individual cashflows as well as the sum based on your IRR input. Once you have completed your IRR calculation check your work with the Excel IRR function
Calculate the EAR of the following investment, entered as a percentage (Example: if your answer is 0.145, enter 14.5) Year Number Cashflow 0 -11400 1 3500 2 3000 3 3100 4 2800 Your Answer:
Calculate the HPR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Period Cashflow 0 -14100 1 3300 2 3300 3 3100 4 2800
Calculate the APR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Year Number Cashflow 0 -11000 1 3000 2 3500 3 2900 4 2800
Determine the future value of the following single amounts Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (EV of $1. PV of $1. EVA of $1.PVA of $1. EVAD of $1 and PVAD of $1) Invested Amount 15.000 20,000 30.000 50,000 1 S 3 234 $ 4 S 1 = ON 0% 12% 4% n = 12 10 20 12 Future Value
launch.jsp?course_assessment_id=_163450_1&course_id=_281293_1&content_id%= 2196275_ دقائق. 1 1 ثانية )ثوان(۔ For a given cash flow diagram, if the interest rate i=10% , and A=$700, the F value is closest to: A F=? Years 3 i=10 % P=$ 4000 $2 $2 فرسال الحعظ والإرسات. ونفرفوق "حفط كل الإجابات"لحفظ كل الإجابات. حفظ كافة الإجابات hp ho 19 44 10 & 7 8. % A toN
What is Project A’s modified internal rate of return (MIRR)? Use 5 decimal places for the factors 18.15% 12.15% 14.49% 7.40% 15.54%
Instruction: Use the table below to acquire information and answer the following questions. Please do not use signs like Rs., $, % etc in your answer. If you calculate percentage as 10.23% than answer must write like 10.23 only (do not write like 10.23% or 0.1023) Year 0 1 2 3 4 Cash flows −$950 $525 $485 $445 $405 Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's discounted payback in years? Answer should correct up to 2 decimal places. Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's net present value? Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's profitability index? Answer should correct up to 2…