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 spreadsheet
Q: Dog Up! Franks is looking at a new sausage system with an installed cost of $715,000. The asset…
A: NPV is also known as Net Present Value.. It is a capital budgeting technique which helps in decision…
Q: a. What is the approximate real rate of interest? (Enter your answer as a percent rounded to 2…
A: The real interest rate is examining the actual value of money. After accounting for fluctuating…
Q: (Market value analysis) The balance sheet for Larry Underwood Motors shows a book value of…
A: Examining a company's financial performance and market valuation is crucial for investors and…
Q: McGilla Golf has decided to sell a new line of golf clubs. The company would like to know the…
A: Selling price of new units = $810Variable cost = $370Marketing study costs = $230,000R&D costs =…
Q: Problem 6-24 Interest Rate Risk (LO3) Consider two bonds, a 3-year bond paying an annual coupon of…
A: This scenario analyzes how rising interest rates affect the prices of two bonds: a three-year bond…
Q: FarCry Industries, a maker of telecommunications equipment, has 26 million shares of common stock…
A: Weighted average cost of capital is popularly known as WACC. A company funds its operations through…
Q: Beasley Enterprises stock has an expected return of 5.49 percent. Given the information below, what…
A: The expected return refers to the profit that the investment provides on average to the investors.…
Q: Should the project be rejected and why?
A: The accounting return is comparing your earnings to your expenses. It is used to calculate the…
Q: Required: You manage an equity fund with an expected risk premium of 14% and a standard deviation of…
A: Equity fund's,Expected risk premium = 13.6%Standard deviation = 50%
Q: You find the following corporate bond quotes. To calculate the number of years until maturity,…
A: Bond price refers to the market value of a bond, which is influenced by factors such as interest…
Q: Summa Laude (Pty) Ltd ("Summa Laude") is an entity that owns various properties that the entity…
A: Cost of property = R1,637,000Cash available = R250,000Interest rate = 10.9%Number of years = 3To…
Q: In the above table, find the Treasury bond that matures in May 2034. What is your yield to maturity…
A: The yield to maturity refers to the amount of money that can be earned by holding a bond to its…
Q: Problem 6-6 (Algo) Consider the following table: Scenario Probability Stock Fund Rate of Return Bond…
A: An investor would wish to analyze how two investment's returns move in coordination with each other…
Q: Lena would like to have 25,706.30 in ordinary and annuity in five years the annuity has a 10.8%…
A: The answer is $ 986.23 She need to deposit $ 986.23 per quarterExplanation:We can use the formula…
Q: Pablo Company is considering buying a machine that will yield income of $3,100 and net cash flow of…
A: Net Present Value is the capital budgeting technique used to evaluate the profitability and the…
Q: Assume both portfolios A and B are well diversified, that E(A) = 14.8% and Erg) = 15.8%. If the…
A: Given:E(ra)=14.8%E(rb)=15.8%βa=1βb=1.1
Q: A property gets following Cash flows: NO, 5th year is constant with 2% the r = 12%. = 100,000…
A: The objective of the question is to calculate the present value of the property considering the…
Q: Suppose Alcatel-Lucent has an equity cost of capital of 10.2%, market capitalization of $11.20…
A: Years0123FCF-$100.00$55.00$103.00$74.00Debt$38.84$31.34$13.57$0.00Interest$0.00$2.52$2.04$0.88Equity…
Q: You deposit $2,239 per year for 14 years, beginning in one year, into an account that pays 12%…
A: Amount = $2,239Number of years =14Interest rate = 12%To find: Total amount in 14 years.
Q: You've collected the following information from your favorite financial website. 52-Week Price Hi…
A: Assuming that the growth rate is constant and lower than the required return, we can use the…
Q: The firm X has sales of $420,000, a tax rate of 32%, the payout ratio of 35%, and a net profit…
A: Retained earnings is the accumulated net income of a company after paying out its dividends. A…
Q: Krista borrowed $17,432 The loan is to be repaid by three equal payments due in 80, 154, and 263…
A: Loan amount = $17,432Interest rate = 7%Equal payments are due in 80,154 and 263 days
Q: Princess Cruise Company (PCC) purchased a ship from Mitsubishi Heavy Industry for 520 million yen…
A: Hedging - Hedging can also be used to protect a corporation's balance sheet when it has invested in…
Q: Hubrey Home Inc. is considering a new three-year expansion project that requires an initial fixed…
A: Operating Cash Flow:It represents the cash flow produced by the company from its regular business…
Q: Beta Company re-invests all of its earnings to fund growth, so they expect to pay no dividends for…
A: Price of the stock is $ 9.65/. Explanation:
Q: Consider a bond with a coupon of 5 percent, seven years to maturity, and a current price of…
A: Face value$1,000.00Coupon rate5%Years to maturity7Current price$1,052.80Yield on bond increases by2%
Q: Use Table 12-2 to calculate the present value (in $) of the ordinary annuity. (Round your answer to…
A: Present value of an ordinary annuity99697.68Explanation:Step 1:we have to calculate the present…
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: I need solution fast
A: The objective of the question is to forecast the net income for the year 2017 based on the given…
Q: 9. Which factor(s) affect a bond rating? a. Likelihood of default b. Seniority of the bond c. The…
A: The first part of the question is asking about the factors that affect a bond rating. Bond rating is…
Q: Q3. A Treasury Note has a coupon rate of 4% (paid semi-annually) and a par value of $100. There are…
A: A Treasury note is a type of government bond issued by the United States Department of the Treasury.…
Q: One year ago, you bought a stock for $57.04 a share. You received a dividend of $2.61 per share last…
A: Capital gains yield is the return arising due to increase in stock price in investment…
Q: Given the following information, what is the standard deviation (in percent) of the returns on this…
A: The standard deviation shows average volatility in the returns of the stock. The higher the…
Q: You have 20 years left for your retirement. You wish to accumulate a sum large enough by that time…
A: To solve this, we need to calculate the future value of an annuity (the amount you'll withdraw…
Q: A 3.750 percent TIPS has an original reference CPI of 180.0. If the current CPI is 206.3, what is…
A: TIPS stands for Treasury Inflation-Protected Securities. These are government-issued bonds designed…
Q: Please help with a discussion on question #2. The base country is Nevis and the countries trading to…
A: For your discussion on question #2 regarding the main foreign currencies that will be used in the…
Q: Given the information below for HooYah! Corporation, compute the expected share price at the end of…
A: The P/E Ratio is a valuation metric that evaluates a company by comparing its current stock price…
Q: Jonas borrowed $8,000 on a 60-day 10% note. Jonas paid $4,000 toward the note on day 40. On day 50,…
A: The objective of the question is to calculate the adjusted balance of Jonas's loan after the first…
Q: Consider two investments A and B with the following sequences of cash flows: Net Cash Flow n Project…
A: The objective of the question is to calculate the Internal Rate of Return (IRR) for two investment…
Q: Westlake Company's stock has an estimated beta of 1.5 and the company just paid a dividend of $2 per…
A: . Westlake's Required Rate of Return using CAPMWe can use the Capital Asset Pricing Model (CAPM) to…
Q: Give answer with calculation and explanation, Provide Correct and Incorrect option explanation
A: The objective of this question is to find out how long it will take for the customer to pay off his…
Q: Nifty Dashboards just paid a dividend of Do = $1.28. Analysts expect the company's dividend to grow…
A: The Dividend Discount Model (DDM) is a method used to value a company's stock by estimating the…
Q: Assume you own a portfolio of diverse securities each of which is correctly priced. Given this, the…
A: The security market line is known for representing the relationship between expected return of a…
Q: Beta Company re-invests all of its earnings to fund growth, so they expect to pay no dividends for…
A: The price of Beta Company's stock today, given the provided conditions, is approximately $10.13.…
Q: A $33,622 portfolio is invested in a risk-free security and two stocks. The beta of Stock A is 2.1…
A: Beta measures a stock's volatility relative to the market; a value of 1 indicates alignment with…
Q: What is the Yield-to-Maturity of a bond with a par value of $1000, a current price of $819.36, 11…
A: The objective of the question is to calculate the Yield-to-Maturity (YTM) of a bond. The YTM is the…
Q: D21 5 6 7 A B fx C D E F G H 8 Price per share 9 Shares outstanding 8,000,000 22.00 Face value of…
A: Before-tax cost of equity18.64%Before-tax cost of debt7.55%Equity weight82.40%Debt…
Q: We are examining a new project. We expect to sell 8,500 units per year at $175 net cash flow apiece…
A: NPV is one of the capital budgeting instruments that can be used where the investor can determine…
Q: Consider the previous question with the following new information: Fixed costs are assumed to be…
A: Operating leverage refers to the degree to which a company's operating costs and, consequently, its…
Q: 31 ation An 8%, 8-year bond pays annual coupons and has 6 years to maturity. If the market interest…
A: The objective of this question is to calculate the price of an 8% 8-year bond that pays annual…
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 spreadsheet
Step by step
Solved in 1 steps
- 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?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?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?
- 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 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 show all steps and formulas in an excel spreadsheet 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)?
- 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. Please show all steps in excel and the excel spreadsheet. 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, use the PMT function to determine what your monthly payment will be. Submit the spreadsheet in Canvas.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. Please show all steps and formulas in an excel spreadsheet. 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)?
- 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)?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?Suppose you want to buy a rent to own house worth P450,000. You made a down payment of 15% of the purchase price and take a 25 year mortgage for the balance. a. What is your down payment? b. What is your mortgage amount? c. What is the total interest charged over the life of the loan if your monthly payment is P2,200? Solve manually in a paper.