Module 02 Written Assiqnment Application of Future Value and Present Value.xlsx - OpenOffice CalcFile Edit View Insert Format Iools Data Window HelpABC《的,ABCVerdana10В I U三開 % 0 □ABGHI1. Assume an investment of $2,000 today. Calculate the FV of the investment according to eac6.7a. 6 percent compounded annually89.Rate6%10NperPMT121112PV$2,000.00$0.0013FV1415b. 8 percent compounded annually1617Rate8%18Nper1219PMT20PV$2,000.0021FV2223c. 10 percent compounded annually2425Rate10%26Nper1227PMT28PV$2,000.0029FV3031d. 10 percent compounded semiannually32RateK Future Value Present Value3310%STDSheet 1/2PageStyle Future Value

Future value is the expected value of current sum at a future date at a given rate of return.

Answered: a. 6 percent compounded annually Rate…

a. 6 percent compounded annually Rate 6% Nper PMT 12 $2,000.00 $0.00 PV FV b. 8 percent compounded annually Rate 8% Nper 12 PMT PV $2,000.00 FV c. 10 percent compounded annually

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: Cash flow Asset End of Year Amount Appropriate required return $ 7,000 7,000 7,000 A 1 9% 3 В 1…

A: Present Value: The present value is the value of cash flow stream or the fixed lump sum amount at…

Q: 8. Calculate Internal Rate of Return from the following information: Initial investment = Rs…

A: IRR is a discount rate that make NPV of project zero. We need to use excel to calculate IRR

Q: Q9) The sum of $500, 000 has been placed in an investment which earns interest at the rate of 12…

A: The interest is credited 4 times a year when the interest is compounded quarterly. The interest is…

Q: Fample Problem: Principal = P150,000 Period P I A rate = 18% 1 term = 1 year compounding mode…

A: The more is compounding more is accumulated interest and more is the future value of money…

Q: PRÒ 1. Ring Co. uses the "installment sales method." Information o - Compute for the realized gross…

A: The installment sales method is a method where profit is recognised when the cash is received.

Q: $26,000.00 $6,150.00 $2,000.00 $2,510.00 Cost of Goods Sold {A} Equipment {B} Renovations {C} Other…

A: Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…

Q: Q11. Find the principal that will amount to $8,000 in 4 years at 6% p.a. compounded monthly. Q12.…

A: The principal value of the future amount can be ascertained by using the formula of present value.…

Q: 2% compounded annually, calcula O a. P 455,875.00

A: The given problem can be solved using PV function in excel. PV function computes loan amount (price…

Q: Case PV FV PMT (end) Interest No. of % p.a. Years P1,500 12% 6 Quarterly P2,000 X 10% 12 Semi-…

A: Use the Excel FV function with the following inputs to determine the future value in case A. RATE =…

Q: Sinking Fund MethodGiven:FC = 2,000,000.00 pesosSV = 300,000.00 pesosi = 12.00%n = 9 yearsa. A = ?b.…

A: Sinking Fund Method Sinking fund method is another useful method to calculate the depreciation for…

Q: 7) Complete the missing variables in the table below; Annual nominal Cmpd/year 1%/yr (nom) 10.0% $…

A: Explanation : 1. Future Value formula in excel : 2. Present Value formula in excel : 3.…

Q: Calculate the simple interest earned on an investment of: $2 000 at 4% per annum for three years…

A: Here, Investment Amount (P) is $2,000 Time Period (T) is 3 years Rate (R) is 4%

Q: 2. PMT = P100,000; I = 8%; n = 10 years; Annually %3D 3. PMT = P50,000; I = 12%; n = 6 years;…

A: Note: 1)Since here it is not specified to solve for the present value of the ordinary annuity or…

Q: 5. Find the compound amount 5, 000 is invested for 3 years and 9 months at 12% compounded…

A: Future Value refers to the value of the current asset or investment or of cash flows at a specified…

Q: $7,480 discounted to the present at 6.33 percent. (Round answer to 2 decimal places, e.g. 15.25.)…

A: Perpetuity is a kind of cash flow that an individual or a corporation receive for infinite no. of…

Q: Total interest expended will be: a. OMR 50,400,000 b. OMR 45,000,000 c. OMR 55,000,000 d. OMR…

A: Interest is an incentive charged by the lender to the borrower for lending his money, interest…

Q: Discount ₱264,000 for 2. 75 years converted quarterly at 10.64%.

A: The concept of time value of money will be applied here. As per the concept of time value of money…

Q: Find the interest on Pnp23, 000 invested for 3 years at 7% compounded quarterly Select the correct…

A: Invested amount (P) = Php 23,000 Annual interest rate = 7% Quarterly interest rate (r) = 7%/4 =…

Q: 5) $120,000; 8% compounded annually; 10 annual payments

A: Interest Rate 8.00% Period (NPER) 10 Present value 0 Future value 120000

Q: 2. P3 500 deposited every 6 months for 10 years at 8% per year compounded semi-annually.

A: Semi annual deposit (P) = P 3500 Period = 10 Years Number of semi annual deposits (n) = 10*2 = 20…

Q: 3. Determine the future values if OMR 5,000 is invested in each of the following situations: a. 5…

A: Future value can be defined as the worth of money at a future date, computed in accordance with the…

Q: IR- 0 per Semiannual compounded Monthly Option B Mterial Handling Option A Facility Automobiles -80…

Q: Determine which is the better investment: 5.31% compounded semiannually or 5.35% compounded…

A: Effective annual interest rate is the rate of interest that is achieved effectively after…

Q: PV Years Percent Compound FV 9.81% Monthly $86,450.00

A: Present value is the current value of a future cash flow at a specific rate of return. It indicates…

Q: A certain investment earns P2,000 in 18 months at a rate of 8% simple interest. How much is the…

A: Simple interest is interest that is paid or calculated solely on the principal sum of money. It does…

Q: he present value of $5,000 payable in 150 days at 8.5% per annum simple interest is: Select one: a.…

A: Present Value under Simple Interest = Future Value /[ 1 + {Interest rate * n}]

Q: 23. Calculate the present value (principal) and the compound interest (in $). Use Table 11-2. Round…

A: The present value and compound interest can be calculated as per the principles of time value of…

Q: (Related to Checkpoint 5.2) (Future value) To what amount will $5,200 invested for 9 years at 9…

A: Compounding is a way to compute the FV of present amount by considering appropriate rate or PVF for…

Q: Principal P405, 000 P750, 000 PI, 320, 000 P5, 600, 000 PI7, 000, 000 Rate Mode of Payment Monthly…

Q: B $5,000 $1,480 A $3,500 $1,655 Capital Investment Annual cash flow Useful life (years) 6

A: The question is related to Capital Budgeting. Present worth cost method is the present value of all…

Q: Find the future value on a $ 3000 investment at 8% compounded semi-annually for 4 years Select one:…

A: future value formula: future value =present value×1+rmm×nwhere,r=rate n=yearsm=frequency of…

Q: uestion 1 The Gloss Celing paid on annual dividend of 164 per shore lost year ond just emounced that…

A: Information Provided; Annual growth rate = 1.13% (is the rate is different, apply that rate to the…

Q: P 1,000,000 Interest payments 10 years Effective yield Face amount July 1 and January 1 Term 12%…

A: Issue price of bonds = Present value of Interest Payments + Redemption value Notes: In absence of…

Q: I f y o u b or r o w e d P 10, 000.00 f r o m a b a n k w i t h 18% interest per annum,…

A: Interest expenses are the charges which the borrower has to pay along with the principal amount…

Q: . J12 equivalent to ji = 10.08% i. equivalent to j4 = 12% . ja equivalent to j = 9% . per month…

A: in this we have to find equivalent rate of interest.

Q: Suppose $5,000 is invested for four years at 4.25% interest compounded quarterly. What is the future…

A: Investment (PV) = $ 5000 Annual interest rate = 4.25% Quarterly interest rate (r) = 4.25%/4 =…

Q: What is the carrying amount of the investment in associate at year-end? a. 2,550,000 b. 2,700,000 c.…

A: Introduction: The number of shares outstanding refers to the total number of shares owned by all of…

Q: 36. The future value of Php 200 received today and deposited at 8 percent for three years is A. Php…

A: In the given question we require to compute the future value from following details: Deposit today…

Q: Determine the effective annual yield for $1 invested for 1 year at 8.5% compounded quarterly.…

A: APY ( effective annual yield ) = (1+ ( APR/N))N - 1 where, APR = Nominal rate N = frequency of…

Q: 35. The future value of Php 100 received today and deposited at 6 percent for four years is A. Php…

A: Details given in the question are as follows: Deposit today (Present value) = Php 100 Time period =…

Q: PV Years Percent Compound FV $9,817.30 27 14.59% Weekly a. $288,108.80 O b. $501,663.75 O c.…

A: No. of weeks=Years×Number of weeks in a year=27×52=1404

Q: Table 2 P m i t n C P a)_ Semi- b)_ c)_ 2 d)_ e). 2,000 annually 2,800 quarterly g) h) 5 yrs and 6 P…

A: The concept of the time value of money(TVM) is working on the purchasing power capacity of money.…

Q: 28. A loan amounting to P100,000 is to be paid annually for 4 years with an interest rate of 10% per…

A: The amortization schedule: A large loan that is taken is usually repaid in smaller equal periodic…

Q: What is the future value of $3,078 invested for 8 years at 6 percent compounded annually? Multiple…

A: Time value of money (TVM) concept refers to the method used to measure the value of money at…

Q: 5. Determine the capitalized cost of an expenditure of P 200,000 at time 0, P 25,000 in years 2…

A: Time value of money (TVM) is used to measure the value of money at different point of time in the…

Question

Module 02 Written Assiqnment Application of Future Value and Present Value.xlsx - OpenOffice Calc
File Edit View Insert Format Iools Data Window Help
ABC
《的,
ABC
Verdana
10
В I U
三開 % 0 □
A
B
G
H
I
1. Assume an investment of $2,000 today. Calculate the FV of the investment according to eac
6.
7
a. 6 percent compounded annually
8
9.
Rate
6%
10
Nper
PMT
12
11
12
PV
$2,000.00
$0.00
13
FV
14
15
b. 8 percent compounded annually
16
17
Rate
8%
18
Nper
12
19
PMT
20
PV
$2,000.00
21
FV
22
23
c. 10 percent compounded annually
24
25
Rate
10%
26
Nper
12
27
PMT
28
PV
$2,000.00
29
FV
30
31
d. 10 percent compounded semiannually
32
Rate
K Future Value Present Value
33
10%
STD
Sheet 1/2
PageStyle Future Value

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

akeAssignmentMain.do?invoker%3D&takeAssignmentSessionLocator=&inprogress%3false hapter 11 Lab Application 全回 Sign ia еBook 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.91X $11,000 15% 9 years 184,644.26X $15,000 12% 5 years 95,292.71 X $36,000 10% 2 years 75,600.00 Feedback > Check My Work For each scenario, use the rate and time components to use the applicable time value of money table to determine the needed factor. Multiply the investment amount by the future value factor to determine the value of end of the period. 6:38 PM G O 4) ENG 13 68°F Sunny 10/26/2021 O P Type here to search hp %24 %24 %24
You have been given the following return data, on three assets-A, B, and C-over the period 2021-2024. Using these assets, you have isolated three investment alternatives: a. Calculate the average portfolio return for each of the three alternatives. b. Calculate the standard deviation of returns for each of the three alternatives. c. On the basis of your findings in parts a and b, which of the three investment alternatives would you recommend? Why? OCTOB a. Calculate the portfolio return over the 4-year period for each of the 3 alternatives. Alternative 1: 7.00% (Round to two decimal places.) Alternative 2: 7.00% (Round to two decimal places) Alternative 3: 7.00% (Round to two decimal places.) b. Calculate the standard deviation of returns over the 4-year period for each of the 3 alternatives. Alternative 1: % (Round to three decimal places)
Spreadsheet Link What is the IRR of the following project?Cash FlowYear0 -32,0001. 9,0002. 10,0003. 15,0004. 7,800 1). 10.8% 2). 11.2% 3). 11.7%4). 12.0% 5). 12.3%
n Ltd is considerinc X O VitalSource Bookshelf: Manageria X G Marian Ltd is considering two mu X ses/1155/quizzes/6003/take - LIBIS - Sampoerna... Dashboard A VitalSource Booksh... O Spotify - Web Player MLA For Show your computation Scooby Doo Ltd is considering two mutually-exclusive projects with the following details: Project A Initial investment is $450,000 Scrap value in year 5 is $20,000 Year: 1 3 4 5 Annual cash flows 200 150 150 55 100 ($000) Project B Initial investment $100,000 Scrap value in year 5 is $10,000 Year: 1 2 3 4 Annual cash flows ($000) 20 20 30 40 40 33%
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
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
Details WACC 0 SGWN-O 1 2 3 4 5 6 7.80% Project A Project B -1225 395 402 423 432 489 512 -2146 592.5 603 634.5 648 733.5 768 1. Construct NPV profile table by using cashflows from Project A and B above. 2. Draw NPV profile 3. Compute crossover rate To receive EC your work has to be done in Excel.
Q1. Revenues Advertisement Salaries Sale of scrape Year 1 100000 4000 20000 Year 2 150000 5000 30000 Year 3 140000 3000 30000 5000 Year 4 110000 30000 Year 5 150000 35000 2000 Initial Investment Rs.200000 required rate of return on investment is 12% Required: (i) NPV, (ii) IRR and (iii) Payback period, and (iv) Discounted Payback Period.
Find the value of P for which the inflows will equal the outflows. Find the effective rate first. Rate Year Outflows 0 1 2 3 4 5 678 9 10 -P -2P -4P -8P -16P $1,530 $2,545 $3,269 $3,490 18% pycd Inflows $24,000 $30,000 $36,000 $42,000 $48,000 $54,000
Spreadsheet Link What is the IRR of the following project? Cash Flow Year 0 32.000 9,000 1. 2 10,000 15,200 7,800 4. 1) 10.8% 2) 11.2% • 3) 11.7% 4) 12.0% 5) 12.3% 234
1. Calculate the Annual rate of return. Solving for Rates - Excel FILE INSERT PAGE LAYOUT FORMULAS DATA REVEW VIEW Calibri 国 Paste BIU - -A-Alignment Number Conditional Format as Cell Cells Formatting Table Styles Clipboard Font. Styles A1 E. What annual rate of return is earned on a $5,000 investment when it grows to $10,750 in six years? (Do not round intermediate calculations and round your final answer to 2 decimal places Present value 5,000 Future value Number of periods Complete the following analysis. Do not hard code values in vour calculations. Annual rate of return s of 10 Next > here to search TPL
MYUSF x|困 My Home CengageNOWv2 |Online teachin X gagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inpro... 844 A project has estimated annual net cash flows of $66,600. It is estimated to cost $466,200. Determine the cash payback period. Round the answer to one decimal place. years Chapter 26 TAKE HOME EXAM Content Area

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS