Question

In: Finance

Complete the following problems using either a financial calculator or a spreadsheet program. Do not use...

Complete the following problems using either a financial calculator or a spreadsheet program. Do not use interim rounding, state your answers as positive values, to two decimal places for dollar or period values and four places for percentages stated as decimals; do not label answers with symbols such as $ or %. For example, “10.5%” should be input as “.1050”

1. Jacinda Herschel wants to buy a car and determines she can afford to pay $295.02 a month for a 3 year loan. The rate on such a loan is 0.0598. How much money can Jacinda borrow?

2.Seamus McIntyre started saving for retirement today by investing $241 in an account earning 0.0888. He plans to continue with monthly contributions of the same amount for 32 years. The present value of his investment is:

Solutions

Expert Solution

1. Per month payment =295.01
Rate per month =0.0598/12
Number of Months =12*3 =36
Money Jacinda can borrow using financial calculator
I/Y=0.0598/12;N=36;PMT=295.02;CPT PV =9700.17
Money Jacinda can borrow =9700.50

2.. Monthly investment =241
Number of Periods =32*12 =384
Rate per month =0.0888/12
PV of this investment using financial calculator
I/Y =0.0888/12,N=384;PMT=-241;CPT PV =30647.85
PV of his investment =30647.85


Related Solutions

Complete the following problems using either a financial calculator or a spreadsheet program. Do not use...
Complete the following problems using either a financial calculator or a spreadsheet program. Do not use interim rounding, state your answers as positive values, to two decimal places for dollar or period values and four places for percentages stated as decimals; do not label answers with symbols such as $ or %. For example, "10.5%" should be input as ".1050" 1. An investment compounding twice a month has an effective rate of 0.1688. The nominal rate is: 2.Brian Burkhardt is...
Instructions Complete the following problems using either a financial calculator or a spreadsheet program. Do not...
Instructions Complete the following problems using either a financial calculator or a spreadsheet program. Do not use interim rounding, state your answers as positive values, to two decimal places for dollar or period values and four places for percentages stated as decimals; do not label answers with symbols such as $ or %. For example, 10.5% should be input as .1050. An investment with quarterly compounding has a nominal rate of 0.0917. The effective rate is:
(This problem can be done using either a spreadsheet or your financial calculator. In either case,...
(This problem can be done using either a spreadsheet or your financial calculator. In either case, show all of your work. In the case of a spreadsheet, please print out the entire spreadsheet and indicate where your answers to the various parts of this problem can be found.) A borrower is given a choice between taking out a CPM loan for $250,000 at an interest rate of four percent (4.00%), or to pay two points and receive an interest rate...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s stock...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places. Lee Airlines plans to issue 25-year bonds with a par value of...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places Fisheye Inc. is investing in a new project costing $20 million. It...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the risk and return, stocks and bonds valuation. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. 1. A $1,000 par value 8-year bond with a 13 percent coupon rate recently sold...
​Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel).13. You are told that if you invest $15,000 per year for10 years (all payments made at the end of each year), you...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Kingston Corp. is considering a new machine that requires an initial investment of $520,000 installed, and has a useful life of 8 years. The expected annual after-tax cash flows for the machine are $76,000 during the first 3 years, $87,000 during years 4 through 6 and $92,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT