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?
Q: Companies A and B have been offered the following rates per annum on a $5 million 10-year loan. USD…
A: Here,AnnualInterest rates on a $5 million 10-year loanSwiss FrancUSD Company X10%LIBOR+0.3%Company…
Q: Use the following to solve questions a. and b. with an excel spreadsheet A house with price of…
A: See the answer in the explanation field.Explanation:Answer information:Step 1:Provided:It is assumed…
Q: Cold Duck Manufacturing Inc. has the following end-of-year balance sheet: Cold Duck Manufacturing…
A: Additional Funds Needed (AFN) is a tool for estimating how much money a business will need in the…
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: Following is information on two alternative investments being considered by Tiger Co. The company…
A: The Internal rate of return (IRR) is a financial metric that measures a project's economic…
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: Portage Bay Enterprises has $4 million in excess cash, no debt, and is expected to have free cash…
A: Free cash flow is the operating cash flow available after the deduction of all expenses, debts and…
Q: Should I hold Worldcoin long-term? Will the Worldcoin currency still rise? Help with analysis!
A: Let's delve into an analysis of Worldcoin to help you make an informed decision. Worldcoin…
Q: The current debate about what corporate objectives should be
A: The current debate with respect to corporate objectives encompasses a wide range of perspectives,…
Q: The balance on a credit card, that charges a 12% APR interest rate, over a 1 month period is given…
A: Finance Charge is the interest charged by credit card companies over an outstanding amount. Average…
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: Suppose you just bought an annuity with 12 annual payments of $15,700 at a discount rate of 11.75…
A: Present value is the discounted value of the cash flows generated by the investment over the period…
Q: Assume that you contribute $150 per month to a retirement plan for 20 year Then you can increase the…
A: Retirement plan refers to an amount that is being invested at every period for the purpose of…
Q: Rare Agri-Products Ltd. is considering a new project with a projected life of seven (7) years. The…
A: Weighted average cost of capital refers to the cost associated with the different structure of the…
Q: The following table summarizes prices of various default-free zero-coupon bonds (expressed as a…
A: Yield to maturity can be refers as the interest rate on bond that can be expected by a bondholder if…
Q: An investor uses £100,000 to buy 7-year bonds with a face value of £100. The bonds pay coupons…
A: Price of the bond refers to the present value of the future earnings and the maturity value at the…
Q: You have the choice of receiving $80,000 now or $30,000 now and another $56,000 two years from now.…
A: The objective of the question is to determine which option is better in terms of today's dollar…
Q: XYZ stock price and dividend history are as follows: Beginning-of- $ 104 Year 2018 Year Price…
A: Return: The difference between the current value of investment and the initial value of investment…
Q: a constant 15 percent growth rate thereafter. What is the dividend yield and capital gains yield for…
A: The dividend yield is similar to the interest you receive on savings accounts, but you invest in…
Q: What is the FCFF of a firm with revenues of $229 million, operating profit margin of 47%, tax rate…
A: Free cash flow (FCF) is a financial metric that represents the cash a company generates from its…
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: With the following information, compute the net benefit of refinancing: Current loan balance:…
A: Refinancing is a financial strategy aimed at securing lower interest rates, reducing monthly…
Q: Which of the following can be facilitated through your brokerage firm Providing investment…
A: The question is asking about the services that can be provided by a brokerage firm. Brokerage firms…
Q: 10) Suppose a coupon bond with 10 years remaining to maturity is reported to have a duration…
A: Years to maturity = 10Duration = 6.7 yearsInterest rate = 9%Decreased interest rate = 8.8%To find:…
Q: The efficient frontier represents a combination of which of the following? a. Only portfolios
A: The efficient frontier represents a combination of:a. Only portfoliosb. A portfolio of risky…
Q: A company is projected to generate free cash flows of $329 million next year, growing at a 5.7% rate…
A:
Q: You are long in a put option with an exercise price of $60. What is the value of the put at…
A: Given that the exercise price is $60:If the stock price at maturity is below $60, the put option is…
Q: You are the loan department supervisor for a bank. This installment loan is being paid off early,…
A: The answer is: Rebate Fraction = 0.83 Finance Charge Rebate = $648.22 Loan Payoff = $1,151.78…
Q: Stock Investment Stock's Beta Coefficient A $160 million 0.7 B 120 million 1.5 с 80 million 2.2 D 80…
A: ProbabilityMarket return0.1-28%0.20%0.413%0.232%0.148%Risk-free rate (Rf)4%StockInvestmentStock's…
Q: Delta Company, a U.S. MNC, is contemplating making a foreign capital expenditure in South Africa.…
A: Net Present Value (NPV) is a financial metric used to assess the profitability and value of an…
Q: Please help with question #2. The based country is Trinidad and the countries trading to is…
A: Question #2: Foreign Exchange Management in a Trinidadian MNC2. Main Foreign Currencies and…
Q: Suppose you just bought an annuity with 10 annual payments of $16,500 at a discount rate of 13.75…
A: The objective of the question is to calculate the present value of an annuity under different…
Q: 1. (a) An organization has $2 million in assets and an earnings beforeinterest and taxes (EBIT)…
A: see the explanation belowExplanation:(a) No Debt FinancingProfit before tax (EBIT) =…
Q: If $1125.00 accumulates to $1248.19 in two years, six months compounded semi-annually, what is the…
A: The objective of the question is to find the effective annual rate of interest when the principal…
Q: Suppose you purchase a 10-year bond with 6.4% annual coupons. You hold the bond for four years, and…
A: A bond pays regular coupons over the period of investment along with par value at the end of the…
Q: Kelly found US$140 in her attic and sold it to a bank that charged her a commission of 0.35%. How…
A: Foreign exchange, often abbreviated as forex or FX, refers to the global marketplace where…
Q: Nighthawk Steel, a manufacturer of specialized tools, has $4,980,000 in assets. Temporary current…
A: Long-Term Financing:Long-term financing refers to obtaining capital or funding for business purposes…
Q: challenge 4 Next, use a financial calculator. You can use your own scientific or financial…
A: The time value of money is a concept in finance that states money today is worth more than the same…
Q: You invest $180 in a mutual fund today that pays 6.80 percent interest annually. How long will it…
A: Compound interest is a concept that plays a crucial role in finance and investing. It refers to the…
Q: The price of a 20-year bond that has a coupon rate of 8% is $1100.The bond pays semiannual coupon.…
A: Calculate the semiannual coupon payment:Coupon rate = 8%Since payments are semiannual, divide the…
Q: The SML helps determine the level of risk aversion among Investors. The higher the level of risk…
A: The level of risk aversion can be determined by determining the steepness of the SML slope. It says…
Q: Question 4 (a) Consider a 3-year forward contract to buy a coupon-bearing bond thatwill mature…
A: a.Initial: Forward Price ≈ $90.903; b.18 Months Later: Forward Price ≈ $85.662.Explanation:Step…
Q: Stocks A and B have the following probability distributions of expected future returns: a. Calculate…
A: Probability 1 = p1 = 0.1Probability 2 = p2 = 0.1Probability 3 = p3 = 0.6Probability 4 = p4 =…
Q: Amalgamated Industries is expected to pay the following dividends over the next three years: $1.75,…
A: “Since you have asked multiple questions, we will answer the first question for you. If you want any…
Q: A 7-year project is expected to provide annual sales of $221,000 with costs of $97,500. The…
A: Worst-case scenario is determined as part of sensitivity analysis. As per this, the revenue and…
Q: Consider a risky portfolio. The end-of-year cash flow derived from the portfolio will be either…
A: This topic revolves around the concept of evaluating the value of a risky portfolio and determining…
Q: what is the value of your retirement plan after the 50 years? (Do not 3 decimal places)
A: The future value can be compared to the projected how much money you will have in the future from…
Q: You are hoping to buy a house in the future and recently received an inheritance of $16, 000. You…
A: The FV of an investment refers to the total value of its cash flows at a particular future date…
Q: One year ago, you purchased a stock at a price of $28.75. The stock pays quarterly dividends of $.35…
A: The objective of this question is to calculate the total capital gains from the investment in a…
Q: Am. 112.
A: The objective of the question is to estimate the overhead costs for Bowen plc if it handles…
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?
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?
- 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?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.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 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 buy a rental property, taking out a 15 year loan with monthly payments and a mortgage rate of 4.7%. Your plan is to pay down the remaining balance after 7 years. How much will that balance be if the value of the loan is $250,000? (Answer to nearest dollar. HINT: you must find the payment before you can find the balance.)Please provide the steps to solving this problem using a financial calculator: You just opened a brokerage account, depositing $3,500. You expect the account to earn an interest rate of 9.652%. You also plan on depositing $4,500 at the end of years 5 through 10. What will be the value of the account at the end of 20 years, assuming you earn your expected rate of return?
- Suppose you take out a $117,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 5%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? b. Construct a mortgage amortization. c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 3%, what is the real value of the first (year-end) payment? g. If the inflation rate is 3%, what is the real value of the last (year-end) payment? h. Now assume the inflation rate is 6% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? i-1. Recompute the amortization table. i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last…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?there is a house on sale for $800,000. You believe you can finance the home for $500,000 for 20 years at a 2% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel.