Download
1 / 1
10 likes | 15 Views
FIN 419 Week 2 Individual Assignment Time Value of Money Calculations//tutorfortune.com<br><br>Click on below link to buy<br>https://tutorfortune.com/products/fin-419-week-2-individual-assignment-time-value-of-money-calculations<br><br>Instructions: Purpose of Assignment The purpose of this assignment is to allow the students to understand and practice the measurement of present value, future value, and interest rate using Microsoftu00ae Excelu00ae. Assignment Steps Resources: Microsoftu00ae Officeu00ae 2013 Accessibility Tutorials, Microsoftu00ae Excelu00ae, Time Value of Money Calculations Template Calculate the following time value of money problems using Microsoftu00ae Excelu00ae: <br>1.tIf we place $8,592.00 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 9.5 years?<br>2.tWhat is the present value of $992 to be received in 13.5 years from today if our discount rate is 3.5 percent?<br>3.tIf you bought a stock for $45 dollars and could sell it fifteen years later for three times what you originally paid. What was your return on owning this stock?<br>4.tSuppose you bought a house for $3,250,000 to make it a nursing home in the future. But you have not committed to the project and will decide in nine years whether to go forward with it or sell off the house. If real estate values increase annually at 1.5%, how much can you expect to sell the house for in nine years if you choose not to proceed with the nursing home project?<br>5.tIf your daughter wants to earn $215,000 within the next twenty-three years and the salaries grow at 4.45% per year. What salary should she start to reach her goal?<br><br>Click on below link to buy<br>https://tutorfortune.com/products/fin-419-week-2-individual-assignment-time-value-of-money-calculations<br>
E N D
FIN 419 Week 2 Individual Assignment Time Value of Money Calculations//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/fin-419-week-2-individual-assignment-time-value-of-money- calculations I n s t r u c t i o n s : P u r p o s e o f A s s i g n me n t T h e p u r p o s e o f t h i s a s s i g n me n t i s t o a l l o w t h e s t u d e n t s t o u n d e r s t a n d a n d p r a c t i c e t h e me a s u r e me n t o f p r e s e n t v a l u e , f u t u r e v a l u e , a n d i n t e r e s t r a t e u s i n g Mi c r o s o f t ® E x c e l ® . A s s i g n me n t S t e p s R e s o u r c e s : Mi c r o s o f t ® O ffi c e ® 2 0 1 3 A c c e s s i b i l i t y T u t o r i a l s , Mi c r o s o f t ® E x c e l ® , T i me V a l u e o f Mo n e y C a l c u l a t i o n s T e mp l a t e C a l c u l a t e t h e f o l l o w i n g t i me v a l u e o f mo n e y p r o b l e ms u s i n g Mi c r o s o f t ® E x c e l ® : 1 . I f w e p l a c e $ 8 , 5 9 2 . 0 0 i n a s a v i n g s a c c o u n t p a y i n g 7 . 5 p e r c e n t i n t e r e s t c o mp o u n d e d a n n u a l l y , h o w mu c h w i l l o u r a c c o u n t a c c r u e t o i n 9 . 5 y e a r s ? Wh a t i s t h e p r e s e n t v a l u e o f $ 9 9 2 t o b e r e c e i v e d i n 1 3 . 5 y e a r s f r o m t o d a y i f o u r d i s c o u n t r a t e i s 3 . 5 p e r c e n t ? I f y o u b o u g h t a s t o c k f o r $ 4 5 d o l l a r s a n d c o u l d s e l l i t fi f t e e n y e a r s l a t e r f o r t h r e e t i me s w h a t y o u o r i g i n a l l y p a i d . Wh a t w a s y o u r r e t u r n o n o w n i n g t h i s s t o c k ? S u p p o s e y o u b o u g h t a h o u s e f o r $ 3 , 2 5 0 , 0 0 0 t o ma k e i t a n u r s i n g h o me i n t h e f u t u r e . B u t y o u h a v e n o t c o mmi t t e d t o t h e p r o j e c t a n d w i l l d e c i d e i n n i n e y e a r s w h e t h e r t o g o f o r w a r d w i t h i t o r s e l l o ff t h e h o u s e . I f r e a l e s t a t e v a l u e s i n c r e a s e a n n u a l l y a t 1 . 5 %, h o w mu c h c a n y o u e x p e c t t o s e l l t h e h o u s e f o r i n n i n e y e a r s i f y o u c h o o s e n o t t o p r o c e e d w i t h t h e n u r s i n g h o me p r o j e c t ? I f y o u r d a u g h t e r w a n t s t o e a r n $ 2 1 5 , 0 0 0 w i t h i n t h e n e x t t w e n t y - t h r e e y e a r s a n d t h e s a l a r i e s g r o w a t 4 . 4 5 % p e r y e a r . Wh a t s a l a r y s h o u l d s h e s t a r t t o r e a c h h e r g o a l ? 2 . 3 . 4 . 5 . Click on below link to buy https://tutorfortune.com/products/fin-419-week-2-individual-assignment-time-value-of-money- calculations
