A loan of $370,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.9%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the first 15 payments. $ c) Find the total amount of interest paid over the life of the loan. $ d) Find the total of all payments made over 30 years. $ Suppose that payment number 3 is skipped and the interest owed for month 3 is added to the balance. Payments then resume as usual for the remainder of the 30 years. e) Find the balance owing at the end of month 3. $ f) Find the balance remaining after the 360th payment. $

A loan of $370,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.9%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the first 15 payments. $ c) Find the total amount of interest paid over the life of the loan. $ d) Find the total of all payments made over 30 years. $ Suppose that payment number 3 is skipped and the interest owed for month 3 is added to the balance. Payments then resume as usual for the remainder of the 30 years. e) Find the balance owing at the end of month 3. $ f) Find the balance remaining after the 360th payment. $

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter2: Risk And Return: Part I

Section: Chapter Questions

Problem 13P

See similar textbooks

Similar questions

A. If a stock costs $55 one month and drops to $45 the next month, what is the expected stock price the next month, if we assume the stock follows a random walk? B. Explain both technical and fundamental analysis and what form of the efficient market hypothesis corresponds to each.
During the past five years, you owned two stocks that had the following annual rates of return: Year Stock T Stock B 1 0.19 0.08 2 0.08 0.03 3 −0.12 −0.09 4 −0.03 0.02 5 0.15 0.04 Compute the arithmetic mean annual rate of return for each stock. Which stock is most desirable by this measure? Compute the standard deviation of the annual rate of return for each stock. (Use Chapter 1 Appendix if necessary.) By this measure, which is the preferable stock? Compute the coefficient of variation for each stock. (Use the Chapter 1 Appendix if necessary.) By this relative measure of risk, which stock is preferable? Compute the geometric mean rate of return for each stock. Discuss the difference between the arithmetic mean return and the geometric mean return for each…
You have estimated the following probability distributions of expected future returns for Stocks X and Y: Stock X Stock Y Probability Return Probability Return 0.1 -12 % 0.2 4 % 0.1 11 0.2 7 0.3 14 0.3 11 0.3 30 0.2 17 0.2 40 0.1 30 What is the expected rate of return for Stock X? Stock Y? Round your answers to one decimal place.Stock X: % Stock Y: % What is the standard deviation of expected returns for Stock X? For Stock Y? Round your answers to two decimal places.Stock X: % Stock Y: % Which stock would you consider to be riskier? is riskier because it has a standard deviation of returns.
The stock market can have three potential returns with the following probabilities. Note "otherwise" is whatever probability it takes for all three probabilities to sum to one. So, if the first two probabilities are each .30, then "otherwise" represents a probability of .40. Probability Return -0.04 0.24 0.38 otherwise 0.00 0.18 What is the stock market's standard deviation? Enter your answer in decimal form, and show 4 decimal places.
Given six years of percentage return of Stock A and Stock B, identify the expected return, and risk of each instrument. Assume that each year, has equal chances of reoccurrence. Stock A Stock B 20X1 10 20 20X2 -15 -20 20X3 20 -10 20X4 25 30 20X5 -30 -20 20X6 20 60 a. Which of the two stocks is riskier? Why? b. Which of the stocks is expected to yield a higher return? Why? c. Where will you invest?
Suppose the returns on a small stock are normally distributed. The historical average return is 18 percent, and the standard deviation is 6 percent. What is the probability that your return on this stock will be no less than 12 percent in a given year? What range of returns would you expect to see 95 percent of the time? What range would you expect to see 99 percent of the time?
Consider a stock portfolio consisting of two units of S' and one unit of S2. Calculate the probability of delta losses over one day, if the daily log-returns (X1, X2) of the stocks are independent with X1 are S = 100, S = 50. N(0.5, 1.1), X2 N(-0.2,0.5) and the current stocks value
Problem: 1. Given six years of percentage return of Stock A and Stock B, identify the expected return, and risk of each instrument. Assume that each year, has equal chances of reoccurrence. Stock A Stock B 20X1 10 20 20X2 -15 -20 20X3 20 -10 20X4 25 30 20X5 -30 -20 20X6 20 60 a. Which of the two stocks is riskier? Why? b. Which of the stocks is expected to yield a higher return? Why? c. Where will you invest? Problem Solving: 1. Suppose you want to buy 10,000 shares of MegaWorld Corporation at a price of 4.00. You put up P10,000 and borrow the rest. What does your account balance sheet would look like? What is your margin? 2. Supposed that in the previous problem you shorted 10,000 shares instead of buying. The initial margin is 60 percent. What does the account balance sheet look like? 3. You deposited P100,000 cash in brokerage account and short sell P200,000 of stocks on margin.…
You are trying to develop a strategy for investing in two different stocks. The anticipated annual return for a $1,000 investment in each stock under four different economic conditions has the probability distribution shown to the right. Complete parts (a) through (c) below. Probability 0.1 0.2 0.4 0.3 a. Compute the expected return for stock X and for stock Y. The expected return for stock X is (Type an integer or a decimal. Do not round.) Economic Condition Recession Slow growth Moderate growth Fast growth Returns Stock X Stock Y - 40 30 80 150 - 110 40 140 210
The annual rate of return on any given stock can be found as the stock's dividend for the year plus the change in the stock's price during the year, divided by its beginning-of-year price. If you obtain such data on a large portfolio of stocks, like those in the S&P 500, find the rate of return on each stock, and then average those returns, this would give you an idea of stock market returns for the year in question. true/false
Suppose that the annual return for particular stock follows the same distribution every year, and that the return for any given year is independent of the returns for any prior years. Based on an analysis of the stock's annual returns over an 12 year period, it is determined that the 95% confidence interval for the stock's expected annual return is given by (-0.1724, 0.2861). Find the volatility of the stock. Use the approximation formula from Berk and DeMarzo. 38.52% 40.90% 42.09% 37.32% 39.71%
Consider the following average annual returns for Stocks A and B and the Market. Which of the possible answers best describes the historical betas for A and B? Years Market Stock A Stock B 1 0.03 0.16 0.05 2 −0.05 0.20 0.05 3 0.01 0.18 0.05 4 −0.10 0.25 0.05 5 0.06 0.14 0.05 a. bA > +1; bB = 0. b. bA = 0; bB = −1. c. bA < 0; bB = 0. d. bA < −1; bB = 1. e. bA > 0; bB = 1.