Home

Can someone help me with a Time value formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-821089%22%20slang%3D%22en-US%22%3ECan%20someone%20help%20me%20with%20a%20Time%20value%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821089%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSTRONG%3E%3CSPAN%3ETime%20value%20%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3EYou%20have%20%241%2C500%20to%20invest%20today%20at%207%25%20interest%20compounded%20annually.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSTRONG%3E%3CSPAN%3Ea.%20%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3EFind%20how%20much%20you%20will%20have%20accumulated%20in%20the%20account%20after%20(1)%203%20years%2C%20(2)%206%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%3Eyears%2C%20and%20(3)%209%20years.%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSTRONG%3E%3CSPAN%3Eb.%20%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3EUse%20your%20findings%20in%20part%20%3CSTRONG%3Ea%20%3C%2FSTRONG%3Eto%20calculate%20the%20amount%20of%20interest%20earned%20in%20(1)%20the%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%3Efirst%203%20years%20(years%201%20to%203)%2C%20(2)%20the%20second%203%20years%20(years%204%20to%206)%2C%20and%20(3)%20the%20third%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%3E3%20years%20(years%207%20to%209).%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSTRONG%3E%3CSPAN%3Ec.%20%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3ECompare%20and%20contrast%20your%20findings%20in%20part%20%3CSTRONG%3Eb.%20%3C%2FSTRONG%3EExplain%20why%20the%20amount%20of%20interest%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%3Eearned%20increases%20in%20each%20succeeding%203-year%20period%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-821089%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-821466%22%20slang%3D%22en-US%22%3ERE%3A%20Can%20someone%20help%20me%20with%20a%20Time%20value%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821466%22%20slang%3D%22en-US%22%3EA.%20Look%20at%20the%20FV%20function.%20%241%2C500%20is%20the%20%22present%20value%22%20(pv).%20The%20periodic%20payment%20(pmt)%20is%20zero.%20If%20you%20enter%20%241%2C500%20as%20a%20positive%20number%2C%20FV%20returns%20a%20negative%20value.%20This%20is%20because%20Excel%20uses%20signed%20cash%20flows%3A%20one%20sign%20(plus%20or%20minus)%20for%20inflows%3B%20the%20opposite%20sign%20for%20outflows.%20If%20you%20want%20a%20positive%20value%2C%20simply%20write%20-FV(...)%20or%20enter%20-1500%20for%20%22pv%22.%20B.%20FV%20gives%20the%20ending%20balance%20after%20%22n%22%20periods.%20Since%20%22pmt%22%20is%20zero%2C%20the%20difference%20between%20FV%20for%20%22n%22%20periods%20and%20FV%20for%20%22n-3%22%20periods%20is%20the%20interest%20earned%20between%20periods%20%22n-3%22%20and%20%22n%22.%20C.%20This%20is%20not%20an%20Excel%20question.%20Inter%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-821467%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20someone%20help%20me%20with%20a%20Time%20value%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821467%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397676%22%20target%3D%22_blank%22%3E%40cgreene27%3C%2FA%3E....%20I%20do%20not%20do%20other%20people's%20homework%3B%20and%20as%20a%20student%2C%20I%20would%20not%20take%20credit%20for%20the%20work%20of%20others.%26nbsp%3B%20But%20I%20can%20offer%20some%20guidance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA.%20Look%20at%20the%20FV%20function.%26nbsp%3B%20%241%2C500%20is%20the%20%22present%20value%22%20(pv).%26nbsp%3B%20The%20periodic%20payment%20(pmt)%20is%20zero.%26nbsp%3B%20If%20you%20enter%20%241%2C500%20as%20a%20positive%20number%2C%20FV%20returns%20a%20negative%20value.%26nbsp%3B%20This%20is%20because%20Excel%20uses%20signed%20cash%20flows%3A%26nbsp%3B%20one%20sign%20(plus%20or%20minus)%20for%20inflows%3B%20the%20opposite%20sign%20for%20outflows.%26nbsp%3B%20If%20you%20want%20a%20positive%20value%2C%20simply%20write%20-FV(...)%20or%20enter%20-1500%20for%20%22pv%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EB.%20FV%20gives%20the%20ending%20balance%20after%20%22n%22%20periods.%26nbsp%3B%20Since%20%22pmt%22%20is%20zero%2C%20the%20difference%20between%20FV%20for%20%22n%22%20periods%20and%20FV%20for%20%22n-3%22%20periods%20is%20the%20interest%20earned%20between%20periods%20%22n-3%22%20and%20%22n%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EC.%20This%20is%20not%20an%20Excel%20question.%26nbsp%3B%20Hopefully%2C%20the%20answer%20is%20%22obvious%22.%26nbsp%3B%20Interest%20is%20earned%20on%20the%20beginning%20balance%20of%20each%20period%20(since%20%22pmt%22%20is%20zero).%26nbsp%3B%20Since%20interest%20is%20%22compounded%22%2C%20think%20about%20what%20happens%20to%20the%20balance%20each%20period.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
cgreene27
Occasional Visitor

Time value You have $1,500 to invest today at 7% interest compounded annually.

a. Find how much you will have accumulated in the account after (1) 3 years, (2) 6

years, and (3) 9 years.

b. Use your findings in part a to calculate the amount of interest earned in (1) the

first 3 years (years 1 to 3), (2) the second 3 years (years 4 to 6), and (3) the third

3 years (years 7 to 9).

c. Compare and contrast your findings in part b. Explain why the amount of interest

earned increases in each succeeding 3-year period

 

1 Reply

@cgreene27.... I do not do other people's homework; and as a student, I would not take credit for the work of others.  But I can offer some guidance.

 

A. Look at the FV function.  $1,500 is the "present value" (pv).  The periodic payment (pmt) is zero.  If you enter $1,500 as a positive number, FV returns a negative value.  This is because Excel uses signed cash flows:  one sign (plus or minus) for inflows; the opposite sign for outflows.  If you want a positive value, simply write -FV(...) or enter -1500 for "pv".

 

B. FV gives the ending balance after "n" periods.  Since "pmt" is zero, the difference between FV for "n" periods and FV for "n-3" periods is the interest earned between periods "n-3" and "n".

 

C. This is not an Excel question.  Hopefully, the answer is "obvious".  Interest is earned on the beginning balance of each period (since "pmt" is zero).  Since interest is "compounded", think about what happens to the balance each period.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies