Please Use an excel spreadsheet and show all of the steps to solve the following Please: You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of $360,000 with interest rate of 4% and 15 years. After 3 years, your house is appreciated to the value of $550,000 and market interest rate goes up to 6.5%. How much money will you make in book after 3 years?
Q: You are going to deposit $3,500 in an account that pays .61 percent interest per quarter. How much…
A: The future value shows the value of the investment after a certain period at a specified rate. It is…
Q: If you place a stop-loss order to sell 500 shares of Nedbank at R130 when the current price is R135,…
A: A stop-loss order is a type of order placed with a broker to sell a security (such as a stock or…
Q: You have looked at the current financial statements for J&R Homes, Company. The company has an EBIT…
A: A stock gives shareholders a claim on a company's assets and profits by representing ownership in…
Q: Please Help me
A: The question is asking about the type of loan in which the borrower initially receives the present…
Q: A firm is expected to pay a dividend of $2.05 next year. In the next four years, dividends are…
A: The dividend discounting model is a model for finding out the current share price of a company on…
Q: You have looked at the current financial statements for J&R Homes, Company. The company has an EBIT…
A: A stock is a capital market security that provides the investor with an ownership interest in the…
Q: Am. 112.
A: The objective of the question is to estimate the overhead costs for Bowen plc if it handles…
Q: The initial cost of one customized machine is $675,000 with an annual operating cost of $14,800, and…
A: Initial cost of machine: $675,000Annual operating cost: $14,800Estimated life: 4 yearsRequired rate…
Q: Find the equated date at which the original payments are equivalent to the single payment. State…
A: The objective of the question is to find the time at which the original payments are equivalent to…
Q: Tamarisk Inc. manufactures cycling equipment. Recently, the vice president of operations of the…
A: Bonds:The bond is the financial instrument that is used by the company to get the loan amount so…
Q: User You are considering buying bonds in ACBB, Inc. The bonds have a par value of $1,000 and mature…
A: The objective of this question is to calculate the expected capital gain or loss if the bond is held…
Q: A stock's returns have the following distribution: Demand for the Company's Products Weak…
A: Expected return:The expected return is the weighted average return of all possible…
Q: Suppose a seven-year, $1,000 bond with a 7.9% coupon rate and semiannual coupons is trading with a…
A: Par value = $1,000Period =7 yearsCoupon rate = 7.90%Yeild to maturity = 6.71%Coupon is payable…
Q: Assume the return on a market index represents the common factor and all stocks in the economy have…
A: Expected return is expressed in percentage where the weights and returns for each stock after…
Q: (please all options information and correct answer) Decreases in the following factors that will…
A: A bond refers to a fixed-income investment instrument issued by governments, municipalities, or…
Q: Lena would like to have 25,706.30 in ordinary and annuity in five years the annuity has a 10.8%…
A: The objective of this question is to find out how much Lena should deposit per quarter in order to…
Q: Martin's Inc. is expected to pay annual dividends of $3.00, $3.50 and $4.00 a share over the next…
A: Dividend in year 1 = $3Dividend in year 2 = $3.50Dividend in year 3 = $4Growth rate = 3%Required…
Q: Suppose you purchase a bond that has an 8,5% annual payment coupon. The bond has a par value of R1…
A: Coupon Rate = c = 8.5%face value = fv = R1000Current Time = ct = 25 YearsCurrent Price of Bond =…
Q: You have been tasked with using the FCF model to value Amara's Jewelry Company. After your initial…
A: Equity beta = 1.7Debt-to-equity ratio = 0.5Tax rate = 21%Risk free rate = 6%Market risk premium =…
Q: Hepl me please
A: The objective of this question is to determine the new duration it would take to pay off a mortgage…
Q: Baird Golf has decided to sell a new line of golf clubs. The clubs will sell for $715 per set and…
A: Cost of asset30100000Estimated life7Depreciation4300000Working capital investment1400000Working…
Q: Real and nominal rates interest Zane Perelli currently has $96 that he can spend today on socks…
A: Real rate of interest defines the return in actual is earned by the investors through providing…
Q: A loan of $384,000 at 5.02% compounded quarterly was to be settled with month end payments of $8,…
A:
Q: A $100,000 mortgage is amortized over 20 years with monthly payments at an interest rate of 8%…
A: The objective of the question is to determine the new duration it would take to pay off the mortgage…
Q: Your firm is contemplating the purchase of a new $555,000 computer-based order entry system. The…
A: IRR is the internal rate of return refers to the percentage of return at which present value of…
Q: You borrow $155,000; the annual loan payments are $12, 490.89 for 30 years. What interes rate are…
A: Borrowed amount = $155,000Annual loan payment = $12,490.89Number of years = 30 Years
Q: Required information Section Break (8-11) [The following information applies to the questions…
A: Shape Ratio : A financial metric known as the Sharpe Ratio evaluates an investment's or portfolio's…
Q: Andouille Spices, Incorporated, has the following mutually exclusive projects available. The company…
A: When the acceptance of an investment alternative automatically results in the rejection of the rest…
Q: If $840.00 accumulates to $1177.12 in three years, nine months compounded quarterly, what is the…
A: The objective of the question is to find the effective annual rate of interest when the principal…
Q: Adrian invested $14,000 in a savings bond that matures today for $41,270. How many years did the…
A: The objective of the question is to find out the number of years Adrian's investment took to grow…
Q: Consider the following project: Period 0 1 2 Net cash flow -100 0 78.55 3 78.55 The internal rate of…
A: When there is a change in the economic value of the asset and leads to a decline in the value over…
Q: QUESTION 3 Sharon has one share of stock and one bond. The total value of the two securities is…
A: The objective of the question is to calculate the yield to maturity (YTM) of the bond. The YTM is…
Q: < Daniel's standard deduction for 2023 is $13,850. a. Classify the following expenses as either…
A: a. Classifying the expenses: - Payment of alimony (divorce finalized in March 2021): Deductible for…
Q: Your company currently has $1,000 par, 6% coupon bonds with 10 years to maturity and a price of…
A: A bond pays regular equal periodic payments over the tenure of the bond and at par value at the…
Q: you deposit money today in an account that pays 13.5% annual interest, how long will it take to…
A: Future value = Present value x (1+i)^twherePresent value = amount deposited today = $1…
Q: A 15 year $5000 par value bond has a 12% semiannual coupon and a nominal yield to maturity of 8.5%.…
A: The objective of the question is to calculate the price of a bond given its par value, coupon rate,…
Q: You are told that if you invest $11,600 per year for 18 years (all payments made at the beginning of…
A: Annual rate of return refers to the percentage of earnings or interest earned on the investment made…
Q: Sky High Co. just paid a dividend of $4.9 per share on its stock (Do). The dividends are expected to…
A: Last paid dividend (D0) = $4.9Constant growth rate (g) = 5% or 0.05Required rate of return (r) =…
Q: Percent of capital structure: Preferred stock Common equity (retained earnings) Debt Additional…
A: Proportion of preferred stock in capital structure = 15%Proportion of common stock in capital…
Q: So($/€) Exchange Rate $ 1.45 = € 1.00 F360($/€) $ 1.48 = € 1.00 Interest Rate APR i$ 4% i€ 3% you…
A: Money has time value and due to which value of money will not be same tomorrow and value will change…
Q: Which of the following statements is CORRECT? a. If a coupon bond is selling at par, its yield to…
A: A bond is a financial instrument that symbolizes a loan that an investor has given to a borrower,…
Q: Question 4 Complete the following table and draw a graph showing how bond price for each bond…
A: Bonds can be referred as financial debt instruments that are being traded in the financial market…
Q: Sparrow Products Industries is currently selling for $57.00. It just paid its annual dividend of…
A: The expected return of the stock is a measure of profitability from investment in the stock. The…
Q: A 15 year $5000 par value bond has a 12% semiannual coupon and a nominal yield to maturity of…
A: Price of the bond refers to the current value of the bond. It is calculated as the present value of…
Q: On January 1, year 1, a machine is purchased at an invoice price of $40,000 . The full purchase…
A: Present Value = pv = $40,000Time = t = 5Interest Rate = r = 12%
Q: The figures below show plots of monthly excess returns for two stocks plotted against excess returns…
A: The difference between the market returns and the return on riskless assets such as T-bill…
Q: fords outstanding bond have a $1000 par value and the mature in 35 years their yiel to maturity is…
A: The objective of the question is to find the nominal coupon interest rate of a bond. The bond's…
Q: i need the answer quickly
A: Making decisions by comparing relative costs is known as the incremental method. Sunk cost and…
Q: Estimate the RAROC on a $1,000,000 loan application by a client in the construction industry. Using…
A: The objective of the question is to calculate the Risk-Adjusted Return on Capital (RAROC) for a loan…
Q: Staton-Smith Software is a new start-up company and will not pay dividends for the first five years…
A: Dividend Discount Model refers to the process of discounting the dividends received over the period…
Please Use an excel spreadsheet and show all of the steps to solve the following Please:
You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of $360,000 with interest rate of 4% and 15 years. After 3 years, your house is appreciated to the value of $550,000 and market interest rate goes up to 6.5%. How much money will you make in book after 3 years?
Step by step
Solved in 1 steps
- Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?Please make an excel spreadsheet and show the formulas in the cells for the problem below and please explain You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of $360,000 with interest rate of 4% and 15 years. After 3 years, your house is appreciated to the value of $550,000 and market interest rate goes up to 6.5%. How much money will you make in book after 3 years?
- Use an excel spreadsheet to show steops to solve the following : You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of $360,000 with interest rate of 4% and 15 years. After 3 years, your house is appreciated to the value of $550,000 and market interest rate goes up to 6.5%. How much money will you make in book after 3 years?Answer the following question using a spreadsheet and the material in the appendix. You would like to buy a house. Assume that given your income, you can afford to pay $12,000 a year to a lender for the next 30 years. If the interest rate is 7% how much can you borrow today based on your ability to pay? What about if the interest rate is 3%? Maximum mortgage at 7%: $ Maximum mortgage at 3%: $You are considering buying a new home and are planning to take out a 30-year, $300,000 mortgage. You are told that the interest rate on your loan will be 3%. You want to figure out how much you will have to pay on the mortgage each month. To analyze your potential loan, you have decided to use Microsoft Excel to calculate the monthly payments. To earn full credit your spreadsheet must contain the following elements: Calculate the required monthly payment using a built-in Excel function. Reference the interest rate via a cell name rather than a cell location Build a 360-month amortization table including the outstanding loan balance at the end of each month. Suppose instead of paying the required monthly payment, you decide to pay an extra $250 per month. How much sooner will you be able to pay off your loan?
- You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of $360,000 with interest rate of 4% and 15 years. After 3 years, your house is appreciated to the value of $550,000 and market interest rate goes up to 6.5%. How much money will you make in book after 3 years? plesae show all steps in an excel spreadsheetYou decide to purchase a house for $260,000. You have saved money so you are able to do a down payment of $20,000. You are able to finance your house by getting a 25 year mortgage with an interest rate of 7%. What are the monthly payments? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Part 2 - Six years later, you decide to calculate your loan balance? (Use a payment value rounded to 2 decimal places. Round your final answer to 2 decimal places.) (Hint. Use the remaining years for “N”). Part 3 - If the house appreciates at 3.12 percent per year, what will be the value of the house in eight years? (Round your final answer to 2 decimal places.) NOTE: Provide a format and show your work (example: N = 6, PV = XXX, I = X%, etc.)You plan to use a 15 year mortgage obtained from a local bank to purchase a house worth $124,000.00. The mortgage rate offered to you is 7.75%. You will make a down payment of 20% of the purchase price. a. Calculate your monthly payments on this mortgage. List in a spreadsheet the cash flow the bank expects to receive from you. Submit the spreadsheet with your answers. b. Calculate the amount of interest and principal for the 60th payment. Show your work. c. Calculate the amount of interest and principal to be paid on the 180th payment. Show your work. d. What is the amount of interest paid over the life of this mortgage?
- Please build an excel spreadsheet and show the formulas to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, use the PMT function to determine what your monthly payment will be. Submit the spreadsheet in Canvas.