You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? Please show your work using excel formulas.
Q: You have Just won the lottery and will receive $490,000 in one year. You will receive payments for…
A: To calculate the present value we will use the below formula Present value =…
Q: Ef 332.
A: Step 1 The worth of a current asset at some point in the future based on an estimated rate of growth…
Q: Annuity due. Reginald is about to lease an apartment for 12 months. The landlord wants him to make…
A: The discount rate refers to the interest rate that is used for discounting the values of future…
Q: If an investor sells an ordinary share at a price above that which he or she originally paid, the…
A: Investor is the person who invests, in stocks and securities of the company. In return, investors…
Q: ASSETS Cash & Marketable Securities Accounts Receivable Inventories Other Current Assets Total…
A: As per our guidelines, we are supposed to answer only 3 sub-parts (if there are multiple sub-parts…
Q: A stock is expected to pay a dividend of $1.50 at the end of the year (i.e., D1 = $1.50), and it…
A: To calculate the stock price in 1 year we will use the below formula Stock price in 1 Year =…
Q: A credit card bill of $660 was due on July 1. Purchase of $375 were made on July 7, and $310 was…
A: Credit card issuing companies charges monthly interest on any unpaid balance. For computing the…
Q: Most products have at least some element of service, such as a warranty, documentation and…
A: Product service refers to the support and assistance provided by a company to customers before,…
Q: A pair of Air Jordan’s cost $61 when first released. Today, Air Jordan’s sell for about $211 a…
A: In order to calculate the day to determine considered the number of time value of money so the…
Q: Write the constraint below as a linear inequality. A canoe requires 6 hours of fabrication and a…
A: Here, X is the number of canoes Y is he number of rowboat. Total number of hours should not exceed…
Q: Transcontinental Pipelines is considering a technical process that is expected to reduce annual…
A: Here, Amount of reduction in Annual Maintenance Cost is $75,000 Interest Rate is 3.8% Compounding…
Q: If the yield curve is downward sloping, what would the expectations theory suggest about expected…
A: Yield Curve: It represents a plotting of interest rates of bonds with equal credit & different…
Q: We have probably all heard about the Bernard Madoff Scandal. As investors we need to have adequate…
A: Financial literacy refers to the knowledge and skills needed to make informed and effective…
Q: Mackenzie received a 5.75% nonsubsidized 15 year student loan for $22,000. Assume she graduates in 4…
A: A non-subsidized loan is a type of loan that accrues interest from the time the loan is disbursed…
Q: Eagle Industries' bonds have a 10-year maturity and a 7.80% coupon paid semiannually. They sell at…
A: A par bond is a bond that is issued at its face value or par value, which is typically $1,000 per…
Q: The table below gives a detailed forecast of the size of the market by production volume. Assume…
A: Production planning is the practice of determining the resources needed to produce future retail…
Q: Nur Inc., is a private company that designs, manufactures, and distributes branded consumer…
A: Relative valuation is a method of valuing an asset or company by comparing it to similar assets or…
Q: Chelsea Menken, of Providence, Rhode Island, recently graduated with a degree in food science and…
A: The debt payments to disposable income ratio is the proportion of the disposable income of the…
Q: In the country of Orcam, the velocity of money is constant. Real GDP grows by 1 percent per year,…
A: Real GDP Growth Rate = 1% Growth rate of Money Stock = 14% Nominal Interest Rate = 14%
Q: You predict that interest rates are about to fall. Which bond will show the biggest price increase?…
A: When interest rates fall, bond prices generally rise. The extent of the price increase, however,…
Q: Jessica owes $75000 to be amortized with equal semi-annual payments over 3 years at j2 = 6%. What is…
A: Step 1 Payment is the exchange of money, products, or services for agreed-upon amounts of acceptable…
Q: Calculate the missing information for the installment loan that is being paid off early. Number of…
A: An installment loan refers to a contract between the lender and the borrower for raising funds in…
Q: A declining balance loan for $3000 entails paying about $275 for each of 12 months, for a total of…
A: When we take loans we have to pay interest. In case of a declining balance loan the interest amount…
Q: Give only typing answer with explanation and conclusion What is the future value of a $2000…
A: Annuity value = $2000 time= 3 years rate of interest = 10%
Q: (b) An investor invested his wealth into three bonds for 7 years. The following table shows the…
A: The internal rate of return (IRR) is the rate that the investment is anticipated to generate. It is…
Q: Theodora received an 8-year PLUS Loan of $17,000 to attend law school for her last 2 years. If the…
A: Step 1 The amount paid each month to repay the loan over the course of the loan is known as the…
Q: A business has two investment choices. Alternative 1 requires an immediate outlay of $2,000 and…
A: Here, Initial Outlay of Alternative-1 is $2,000 Initial Outlay of Alternative-2 is $3,000 Return in…
Q: Ken spent 1/4 of his money and an additional $6 on a number of CDs. He then spent 3/5 of the…
A: Let the amount now be “X’, Amount spent on CD is x/4+$6. Amount spent on magazine is “(X-X/4)*3/5 +…
Q: Liam plans to print the Scenarios section of the Loan Calculator Prepare for printing as follows:…
A: In the first scenario, Liam is considering borrowing additional money to renovate the Charles Street…
Q: Using common-size balance sheet percentages to project individual assets, liabilities, or…
A: In a common size balance sheet we show all different line items as a percentage of total assets.…
Q: Amalgamated Industries' common stock is expected to pay a dividend of $3.25 per year for 12 years…
A: Dividend = d = $3.25 Time = t = 12 years Required rate of return = r = 11%
Q: A$110,000 mortgage is amortized over 25 years. If interest on the mortgage is 6.5 percent compounded…
A: Firstly we will convert compounding semi-annually to monthly compounding because payment size is…
Q: Duffs Co. Is growing quickly. Dividends are expected to grow at a 24% rate for the next three years,…
A: In calculation of stock price, with consider expected dividend of the stock and considering the…
Q: Demonstrate how individual and portfolio credit risk management issue can be resolved through the…
A: Risk management is the process of identifying, assessing, and prioritizing risks, and then…
Q: Peaceful Cruises wants to build a new cruise ship that has an initial investment of $200 million. It…
A: Discounted payback period (DPP) is a financial metric used to evaluate the feasibility of an…
Q: You have $12,457.52 in a brokerage account, and you plan to deposit an additional $5,000 at the end…
A: The Future Value of Ordinary Annuity refers to the concept which determines the sum total of all the…
Q: an adjustable rate mortgage (ARM) of $190,000 with a maturity of 30 years and monthly payments. At…
A: In this question Adjustable Rate Mortgage ( ARM) $190,000 with 30 Years maturity and monthly…
Q: As an investor with a two-year desired holding period, you have the option of buying a one-year…
A: To determine which investment is better, we need to calculate the present value of the cash flows…
Q: At the end of every year an investor pays £2,000 towards additional voluntary contributions to build…
A: A pension fund is a type of investment fund that is set up to provide retirement income to employees…
Q: You wish to purchase a home for $500,000. You will make payments of $30,000 at the end of every…
A: A sum borrowed to meet specific personal or business funding needs is recognized as a loan/mortgage.…
Q: Option B: Should she repay the loan back in 5 years at 2.9% making monthly payments? Cost of…
A: The Monthy payments refer to the loan amount that is to be repaid by the borrower to the lender…
Q: Ken spent 1/4 of his money and an additional $6 on a number of CDs. He then spent 3/5 of the…
A: Working Note#1 Let "x" be the remaining money after buying a number of CDs. x-(35 x+$12)= $18 x-…
Q: A company has to make a decision about expanding its production facilities. Research indicates that…
A: As per the given information: Immediate outlay = $130,000Further outlay in 3 years= $20,000Required…
Q: lottery winner has a decision between a lump sum of $1,000,000 or a 20 year annuity of $100,000 paid…
A: The PV of the investment refers to the accumulated value of the discounted cash flows of the…
Q: Give only typing answer with explanation and conclusion An online store holds a sale. Of the 400…
A: Step 1 A coupon is a ticket or piece of paper that can be used to get a cash discount or rebate when…
Q: Your company has sales of $97,200 this year and cost of goods sold of $71,200. You forecast sales…
A: The percent of sales method is a financial analysis technique that is used to estimate future…
Q: The 10-year historical return of your new mutual fund investment is 9.64%. During that same 10-year…
A: The expected return refers to the amount that the investment provides to the investor on average for…
Q: You need to have $30,750 in 11 years. You can earn an annual interest rate of 6 percent for the…
A: To calculate the deposit amount we will use the below formula Deposit amount =…
Q: A contract requires lease payments of $800 at the beginning of every month for 6 years. a. What is…
A: The present value of an annuity due is the value of a series of equal payments that occur at the…
Q: You purchased a call option on TSLA with an exercise price of $180 for a premium of $5.0 and held it…
A: An option is the type of derivative that allows the investor to buy or sell a stock/asset at an…
You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? Please show your work using excel formulas.
Step by step
Solved in 2 steps with 2 images
- 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.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.Suppose you need to borrow $200,000 to buy a home, and you are deciding between a 15 year mortgage and a 30 year mortgage. Research a bank offering 15 year and 30 year mortgage loans and find the interest rates on those loans. Use the techniques you learned in this Module to do the following: 1. Calculate the monthly payment for a 15-year mortgage and for a 30-year mortgage. 2. Find the total amount of interest you will pay on the 15 year mortgage and on the 30 year mortgage. 3. Describe some of the factors (financial and non-financial) that can influence whether to obtain a shorter term mortgage or a longer term mortgage. 4. Which mortgage would you take, the 15 year or the 30 year? Explain your decision.
- You are considering purchasing a new home. You will need to borrow AED 4,000,000 to purchase the home. A mortgage company offers you a 10-year fixed rate mortgage at 12% APR. If you borrow the money from this mortgage company, what is your monthly mortgage paymentYou 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?I need help solving this on excel 9.You a buying a home for $425,000 and would like to determine the monthly mortgage payment. You can obtain a $340,000 30-year fixed-rate mortgage at 3.5%. What is your monthly payment?
- You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? how would i calculate this in excel?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 need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? Plese show your work.
- 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?You plan to purchase a $100,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 8.25 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, principal paid in the 25th payment. (pls show solution)You are considering purchasing a new home. You will need to borrow $280,000 to purchase the home. A mortgage company offers you a 20-year fixed rate mortgage (240 months) at 9% APR (0.75% month). If you borrow the money from this mortgage company, your monthly mortgage payment will be closest to: A. $2,015 B. $3,527 C. $4,030 D. $2,519