A $10,000 car loan has payments of $361.52 due at the end of each month for...
A $10,000 car loan has payments of $361.52 due at the end of each month for three years. What is the annual interest rate?
The Tried and True Corp had earnings of $0.20 per share in 1978. By 1995, a period of 17 years, its earnings had grown to $1.01 per share. What was the compound annual rate of growth in the company’s earnings?
Please Show Work In Excel
Homework Answers
| 1 | PV | 10000 |
| Monthly payment | 361.52 | |
| Term | 36 | |
| Monthly interest rate | 1.50% | |
| Annual interest rate | 18.00% |
We find rate using the RATE function in excel in both cases as per formulae attached.
| 2 | PV | 0.2 |
| N | 17 | |
| FV | 1.01 | |
| Annual rate | 9.99% |
WORKINGS
Add Answer to:
A $10,000 car loan has payments of $361.52 due at the end of
each month for...
Problem 3. A loan of $10,000 is being repaid with payments of $1,000 at the end...
Problem 3. A loan of $10,000 is being repaid with payments of $1,000 at the end of each year for 20 years. If each payment is immediately reinvested at 5% effective, find the effective annual rate of interest earned by the lender over the 20-year period.
Your car loan requires payments of $300 a month for the first year and payments of...
Your car loan requires payments of $300 a month for the first year and payments of $500 per month the second year. The annual interest rate is 6%, and payments begin in one month. What is the present value of this two-year loan?
Suppose you borrow $10,000. You are going to repay the loan by making equal annual payments...
Suppose you borrow $10,000. You are going to repay the loan by making equal annual payments for five years. The interest rate on the loan is 14% per year. Prepare an amortization schedule for the loan.
If you invest $17,500 per year for 17 years (all payments made at the beginning of each year)
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).17. If you invest $17,500 per year for 17 years (all payments made at the beginning of each year), you will have accumulated...
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and...
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. Wha...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years...
A corporation has 10,000 bonds outstanding with a 6% annual coupon rate and 8 years to...
A corporation has 10,000 bonds outstanding with a 6% annual coupon rate and 8 years to maturity. Each bond has a $1,000 face value and a $1,100 market price. • The company’s 1,250,000 shares of common stock sell for $10 per share. • The company will pay $1.2/share in dividend next period, the steady growth of dividend 4%/period is expected to last infinitely. • Tax rate is 40%. 1. What is the company’s cost of debt? 2. What is the...
HW#3 EE401 Calculate the interest and total amount due at the end of the loan for...
HW#3 EE401 Calculate the interest and total amount due at the end of the loan for both simple and compound interest. Loan (a) $ 1000 (6) $ 1500 (c) $10,000 (d) $25,000 (e) $47,750 Years Rate 2 5% 5 6% 10 10% 15 15% 20 20% The following cash flows are equivalent in value if the interest rate is i. Which one is more valuable if the interest rate is 2i? (1) 0— 1— 2 (i) 0— 1— 273 3....
Show all excel formulas used Ex. 3 JIf a dealer offers you a car at $275...
Show all excel formulas used
Ex. 3 JIf a dealer offers you a car at $275 monthly payment for 5 years plus $5,000 down. If you can get a similar loan from a bank at APR of 12%, what is the price that you're paying? Down payment Monthly payment Loan period months APR No. of compounding times per year Monthly rate Present Value Book formula Excel function Ex. 4 If you take out an $10,000 car loan that call for...
Teddy Corp. has 10,000 bonds outstanding with a 6% annual coupon rate, 8 years to maturity,...
Teddy Corp. has 10,000 bonds outstanding with a 6% annual coupon rate, 8 years to maturity, a 1,000 face value, and a 1,100 market price. b) Teddy Corp. 100,000 shares of preferred stock pay an annual dividend of 3, and currently sell for 30 per share. c) Teddy Corp. 500,000 shares of common stock currently sell for 25 per share. The stock has a beta of 1.5. The risk free rate is 4%, and the market return is 12%. Assuming...
Problem 3. A loan of $10,000 is being repaid with payments of $1,000 at the end of each year for 20 years. If each payment is immediately reinvested at 5% effective, find the effective annual rate of interest earned by the lender over the 20-year period.
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
HW#3 EE401 Calculate the interest and total amount due at the end of the loan for both simple and compound interest. Loan (a) $ 1000 (6) $ 1500 (c) $10,000 (d) $25,000 (e) $47,750 Years Rate 2 5% 5 6% 10 10% 15 15% 20 20% The following cash flows are equivalent in value if the interest rate is i. Which one is more valuable if the interest rate is 2i? (1) 0— 1— 2 (i) 0— 1— 273 3....
Show all excel formulas used
Ex. 3 JIf a dealer offers you a car at $275 monthly payment for 5 years plus $5,000 down. If you can get a similar loan from a bank at APR of 12%, what is the price that you're paying? Down payment Monthly payment Loan period months APR No. of compounding times per year Monthly rate Present Value Book formula Excel function Ex. 4 If you take out an $10,000 car loan that call for...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago