I need help with my homework for my finance class. I will attach the questions. This is due by Tuesday, Sept 22. thanks

Homework Assignment for Week 6: For Week 6, please turn in the answers to the following questions: 1. Why do we say money has time value? 2. Why is it important for business managers to be familiar with time value of money concepts? 3. Define Present Value. 4. Define Future Value. 5. What are present value and future value interest factors? (as in PVIF and FVIF) 6. (calculating future value) You buy a 6 year, 8% CD for $1,000. Interest is compounded annually. How much is it worth at maturity? 7. (calculating present value) What's the present value of $1,000 to be received in 8 years? (Your required rate of return is 7% a year.) 8. (calculating the rate of return) A friend promises to pay you $600 two years from now if you loan him $500 today. What interest rate is your friend offering you? 9. (calculating the future value of an annuity) If you invest $100 a year for 20 years at 7% annual interest, how much will you have at the end of the 20th year? 10. (calculating the present value of an annuity) How much would you be willing to pay today for an investment that pays $800 a year at the end of the next 6 years? (Your required rate of return is 5% a year.) Disscusion Questions: the main topic for week 6 is Time Value of Money. This will be the most challenging financial concept in the entire course...however, learning the concepts will be a valuable tool to add to your toolbox of skills. NOTE: I've put a helpful memo on how to do all kinds of TVM applications using Excel, in Announcements. I have Windows 7 2010 so if you have a different version my commands may not work the same for you. If you instead choose to do it long hand, the hard way, get lots of paper, and I will pray for you. TVM has many applications, such as: calculating your mortgage 1 and car payments, figuring out how much you have to save up for retirement planning, how a firm decides to invest in project A vs B, how to answer the main question when you win the lottery, etc., etc. So try these all...don't wait till Sunday to try them; I'll try and check each day to give you quick feedback to help you on the homework. 1 . You and your friend both want to save up to buy a $1000 computer, 3 years from now. You have a track record of earning 10% on your investments, your friend has a track record of earning 5% on her investments. WHO has to start out with the bigger amount of money, today? WHY? 2 . Whats the FUTURE value or FV of putting $1 in a savings account today, and leaving in there for 2 years, if the bank is paying 10%? If its only paying 5%? . What the PRESENT value or PV of receiving $1.21 two years from now, if you have a track record of earning 10% on your money . NOW, the one everyone is waiting for: Congrats You have just won the lottery You are asked whether you want the $10,000,000 lump sum or a 20 year, $700,000/yr annuity IGNORING taxes, how old you are, how sick you are, the likelihood of Tsunamis, whether the State Lottery will be bankrupt in 5 years, whether you want to leave $ to your kids..... On what basis do you make your decision?? [remember, you are in a finance class] 3 4 Using Excel for TVM calculations REV2: There are 4 methods to do TVM calculations: 1. the longhand method of multiplying exponential formulas 2. using any of the 4 TVM tables 3. using excel 2 4. using a financial calculator In my opinion method 1 is too difficult. #2 takes too long; #3 I cannot help anyone with as every different calculator has its own 100 page instruction book The easiest way is learning to use excel. A. To use excel, hit the \"Fx\" toolbar, and choose \"financial\" functions from the pulldown menu To do any kind of present value problem, go to the PV function To do any kind of FV problem, go to the FV function Whichever function you choose will open a window into which you will type in data Guidelines to follow: B. The \"rate\" means the decimal format of the discount or interest rate PER PERIOD to use; if its 5%, type in .05....if its 12% type in .12. If instead of annual compounding, for example if problem dealt with semiannual compounding, and annual rate was 10%, you would type in .05. C. \"Periods\" means the number of compounding periods. If problem is 10 years, compounded annually, type in 10; if its 10 years compounded semi-annually, type in 20 D. means what the future sum would be. E. \"Payment\" field would only be filled in if its an annuity [a stream of equal periodic payments like a car loan or mortgage], in which case you would type in the size of the periodic payment. Otherwise, leave it blank. F. Generally money paid in [like to a bank], should have a negative sign, and your answer will come out positive then Specific examples: 1. For determining the PV of some future some, use the PV function, type in your discount rate as a decimal, type in the number of periods, and type in the future value. If its an annuity, type in the $ amount of the periodic payment in the \"payment\" field. 2. For determining the Future value of some present sum, use the FV function and enter info as above whether its one present sum, or its an annuity stream 3. If instead of a simple end of period annuity problem, its an \"annuity due\" problem [payment on the first day of the period vs., the last day, like an ordinary annuity], type \"1\" into the \"type\" field 4. Determining the effective annual rate: EAR 3 Go to financial section of Fx toolbar, using pull down window to get \"effective\". Type in the nominal or stated ANNUAL percentage rate[APR], as a decimal[12% would be .12] and type in the number of compounding periods per year[if monthly compounding type in 12; if weekly compounding type in 52]. The answer should ALWAYS be >ANNUAL rate you typed in, unless its annual compounding in which case APR=EAR 5. Loan payment: to determine the size of the equal periodic loan payment, use the \"payment\" function, PMT. Type in the loan interest rate per period, as a decimal; if its an annual 12%, then its 1% per month, for example. Type the value of the money to be borrowed, in PV; type in the number of loan periodic payments. If you want the monthly loan payment, make sure the interest rate is expressed as \"per period\" 6. For bond YTM problems Use the \"rate\" function; type in number of periods, any periodic payment, what you are paying out [with a negative sign], what you get back as FV 7. Valuing a bond: Time value of money principles can be used to answer the question. \"what is the appropriate market price, or value of a certain bond, which has a coupon or interest rate R, a face value of F, and has Y years left to maturity.\" As we go through this you'll better understand why financial newscasters will frequently say \"rising interest rates\" cause a fall in bond prices, and lowering interest rates causes an increase in bond pricing-not trivial events when we're talking about billions of dollars in bonds traded everyday. The value of a bond is made up of two pieces-the PV of its face value upon maturity and the present value of the stream of coupon or interest payments over its remaining time to maturity. To determine the PV of a bond you need to determine the PV of each of these components. The present value of the face value is simply the maturity value ($1000 most of the time) discounted by the number of periods remaining at the appropriate discount rate. Always remember, your investment track record or discount rate may be higher or lower than the other party in the transaction of buying and selling a bond. The present value of the stream of remaining coupon payments can be determined through a series of individual PV calculations or one annuity calculation Example: 4 Maturity=30 years, but 5 years have passed already since the bond was initially issued and purchased so there's 25 years left Coupon rate=10% so annual interest payment is $1000 x .1=$100 Face value=$1000 Your personal investment track record of earnings, [or your discount rate]=6% What's the bonds appropriate price, or market value or... \"PV? You COULD do this in two pieces..... a. PV of the face value I=.06, n=25, PMT=0, FV=1000 equals $233 b. PV of the annuity stream of interest payments= I=.06, n=25, PMT=10% x 1000=100; FV=0 equals 1278.30 Total PV of these two pieces=$233+$1278.30=$1511 OR, using excel do it in one step I=.06 n=25, PMT=100, FV=1000 As this is greater than the par or face value, its termed selling or valued or priced.... \"at a premium\". Why would it sell as a premium? Compare your personal discount rate of 6%, with the coupon interest rate of 10%. You could do much better than usual by buying my bond at 10% interest; in fact its so good a deal that you're going to be willing to pay me a \"premium\" to buy it. Guess what would happen if your discount rate was HIGHER than the bonds coupon rate....yes, its PV would be