1. Find the SIMPLE interest that would be received on a $6,500 investment at 5.5% simple...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Find the SIMPLE interest that would be received on a $6,500 investment at 5.5% simple interest for 5 years, and show how much you would have (future value) at the end of the 10 years. (Show Work) 2. Calculate the future value of a $4,000 CD earning 5% interest for 5 years under the following scenarios (use a calculator for the algebraic formula answer, check using the FV function). (in Excel use =FV(i,n,0,(PV),0). Make PV negative because it is a cash out-flow. (Use the EXP function for the continuous compounding problem.) Algebraic Formula Answer A. Compounded yearly: B. Compounded twice a year C. Compounded quarterly: D. Compounded monthly E. Compounded continuously 3. A. B. C. Find the present value of $15,000 you expect to receive 20 years from now using an annual discount rate of 5.8%. (use a calculator for the algebraic formula answer, check using the =PV function). Show Work Discounted yearly: Discounted quarterly: Discounted monthly: Spreadsheet Formula Answer Spreadsheet fn 4. Assume you just inherited $5,000 from a deceased relative and you choose to invest it to start saving for the down payment on a pickup you plan to purchase 3 years from now. You are considering the following choices: A local bank is offering a certificate paying 2.95% compounded quarterly; and a reputable investment firm is offering a certificate paying 2.92% compounded monthly. Ignoring for now taxes and other special considerations, carefully evaluate your opportunities. Choose an investment and defend your choice. (solve each using algebra formulas, then check with spreadsheet function and include in the spreadsheet you submit for this assignment.) Bank: Investment firm: Your Conclusion: 5. A shark tank venture capitalist offers to loan you $100,000 today to purchase facilities for your new business idea, if you will promise to pay her back $245,000 in a lump sum 10 years from now. What annual interest rate is she using? Show algebraic work and also solve using the appropriate finance function. (hint, in Excel you will need to carry the answer out to at least a couple places past the decimal, or it will round it too much) 6. How many years will it take $10,000.00 to turn into $80,000.00 at a rate of 10% per you year (annual compounding)? Use the rule of 72 to approximate, then confirm that are close using the appropriate algebraic or Excel finance function. 1. Find the SIMPLE interest that would be received on a $6,500 investment at 5.5% simple interest for 5 years, and show how much you would have (future value) at the end of the 10 years. (Show Work) 2. Calculate the future value of a $4,000 CD earning 5% interest for 5 years under the following scenarios (use a calculator for the algebraic formula answer, check using the FV function). (in Excel use =FV(i,n,0,(PV),0). Make PV negative because it is a cash out-flow. (Use the EXP function for the continuous compounding problem.) Algebraic Formula Answer A. Compounded yearly: B. Compounded twice a year C. Compounded quarterly: D. Compounded monthly E. Compounded continuously 3. A. B. C. Find the present value of $15,000 you expect to receive 20 years from now using an annual discount rate of 5.8%. (use a calculator for the algebraic formula answer, check using the =PV function). Show Work Discounted yearly: Discounted quarterly: Discounted monthly: Spreadsheet Formula Answer Spreadsheet fn 4. Assume you just inherited $5,000 from a deceased relative and you choose to invest it to start saving for the down payment on a pickup you plan to purchase 3 years from now. You are considering the following choices: A local bank is offering a certificate paying 2.95% compounded quarterly; and a reputable investment firm is offering a certificate paying 2.92% compounded monthly. Ignoring for now taxes and other special considerations, carefully evaluate your opportunities. Choose an investment and defend your choice. (solve each using algebra formulas, then check with spreadsheet function and include in the spreadsheet you submit for this assignment.) Bank: Investment firm: Your Conclusion: 5. A shark tank venture capitalist offers to loan you $100,000 today to purchase facilities for your new business idea, if you will promise to pay her back $245,000 in a lump sum 10 years from now. What annual interest rate is she using? Show algebraic work and also solve using the appropriate finance function. (hint, in Excel you will need to carry the answer out to at least a couple places past the decimal, or it will round it too much) 6. How many years will it take $10,000.00 to turn into $80,000.00 at a rate of 10% per you year (annual compounding)? Use the rule of 72 to approximate, then confirm that are close using the appropriate algebraic or Excel finance function.
Expert Answer:
Answer rating: 100% (QA)
Here are the solutions to the time value of money problems 1 Simple interest on 6500 at 5... View the full answer
Related Book For
Principles Of Managerial Finance
ISBN: 978-0136119463
13th Edition
Authors: Lawrence J. Gitman, Chad J. Zutter
Posted Date:
Students also viewed these finance questions
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
For each problem, show your work steps. A correct answer with no work shown gets half credit (which means you fail the assignment). An incorrect answer with no work receives 0 credit. With time value...
-
The tasks must you complete as part of building the subledger applications while implementing Oracle Accounting Hub Cloud? Explain.
-
Fultz Companys organization chart includes the president; the vice president of production; three assembly plantsDallas, Atlanta, and Tucson; and two departments within each plantMachining and...
-
The 15 Percent Pledge calls on retailers to increase the shelf space allocated to Black-owned brands to at least 15 percent to reflect the approximate percentage of the Black population in the United...
-
The built-up shaft consists of a pipe AB and solid rod BC. The pipe has an inner diameter of 25 mm and outer diameter of 30 mm. The rod has a diameter of 15 mm. Determine the average normal stress at...
-
The unadjusted and adjusted trial balances for Editorial Services Co. on March 31, 2014, are shown below. Journalize the five entries that adjusted the accounts at March 31, 2014. None of the...
-
In November, Trinity Donuts incurred $8850 in total costs related to the production of 3500 donuts. In December, Trinity incurred $8600 in total costs. Total fixed costs are $1850 per month. By how...
-
The first day of work for Prevosti Farms and Sugarhouse for all employees is February 1, 2022. February 4 is the end of the first pay period and includes work completed during the week of February...
-
Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet accounts as of January 1 are given below. Star Videos, Inc. Balance Sheet January 1 Assets $...
-
Does Fairmont have any personnel whose last name is similar?
-
How many forms of main() are there?
-
In Section 9.5.3, we described how a generalized least squares (GLS) estimator for \(\alpha\) and \(\beta_{0}\) in the regression model \(y_{t}=\alpha+\beta_{0} x_{t}+e_{t}\), with...
-
What is the primary purpose of admission-seeking questions?
-
What happens if you specify an invalid format string?
-
A loan of 80,000 is repaid using the amortisation method by annual payments at the end of each year for ten years. The first payment, one year from today is X. Each subsequent payment is 1,600...
-
Calculate Total Contribution Margin for the same items. Total Revenue Total Variable Costs Total Contribution Margin $50.00 a. $116.00 $329.70 b. $275.00 $14,796.00 $7,440.00 c. $40,931.25 d....
-
Home Health, Inc., has come to Jane Ross for a yearly financial checkup. As a first step, Jane has prepared a complete set of ratios for fiscal years 2011 and 2012. She will use them to look for...
-
Tom Baldwin can invest $6,300 in the common stock or the warrants of Lexington Life Insurance. The common stock is currently selling for $30 per share. Its warrants, which provide for the purchase of...
-
Briefly describe the basic format of the cash budget.
-
The chapter provides sample goals for an initial sales call on a prospect. (a) What other goals can you come up with that might be appropriate for an initial sales call? (b) Develop three or four...
-
What are some reasons a potential prospect might not be readily accessible? How far should you go to try to overcome such an accessibility problem before you move to the next lead?
-
List three or four criteria you could use to qualify a lead as a likely prospect. How would you find out if the lead meets these criteria?
Study smarter with the SolutionInn App