Related questions
John Benson and Jerry Chen, the owners of J&J Bagel, Inc., have decided that it is time to acquire
a bigger store to expand their operations. John and Jerry have identified a suitable structure that is
currently for sale, and they believe they can buy and refurbish it for about $2.2 million. John and Jerry are
now ready to meet with Charlene Mons, the loan officer for Blue Hills Bank. The meeting is to discuss
the mortgage options to the company to finance the new store.
Charlene begins the meeting by discussing a 30-year mortgage. The loan would be repaid in equal
annual installments. Because of the previous relationship between J&J Bagel and the bank, there would
be no closing costs for the loan. Charlene states that the interest rate of the loan would be 7 percent. John
asks if a shorter mortgage loan is available. Charlene says that the bank does have a 15-year mortgage
available at the same interest rate.
Jerry decides to ask Charlene about a “bullet loan” he discussed with a mortgage broker when he
was refinancing his home loan. Charlene goes on to explain a bullet loan. The annual payments of a bullet
loan would be calculated using a 30-year traditional mortgage. In this case, there would be a 5-year bullet.
This would mean that the company would make the mortgage payments for the traditional 30-year
mortgage for the first five years, but immediately after the company makes the 5th annual payment, the
bullet payment would be due. The bullet payment is the remaining principal of the loan. Jerry then asks
how the bullet payment is calculated. Charlene tells him that the remaining principal can be calculated
using an amortization table, but it is also the
payments for the 30-year mortgage.
John has also heard of an interest-only loan and asks if this loan is available and what the terms
would be. Charlene says that the bank offers an interest-only loan with a term of 10 years and an interest
rate of 5 percent. She goes on to further explain the terms. The company would be responsible for making
interest payments each year on the amount borrowed. No principal payments are required. At the end of
the 10-year term, the company would repay the $2.2 million. However, the company can make principal
payments at any time. The principal payments would work just like those on a traditional mortgage.
Principal payments would reduce the principal of the loan and reduce the interest due on the next
payment.
John and Jerry are satisfied with Charlene’s answers, but they are still unsure of which loan they
should choose. They have asked her to answer the following questions to help them choose the correct
mortgage.
Questions
(Please use Excel in your calculations to receive extra points)
1. What are the annual payments for a 30-year traditional mortgage? What are the payments for a
15-year traditional mortgage?
2. Prepare an amortization table for the first six years of the traditional 30-year mortgage. How
much of the first payment goes toward principal?
3. Repeat question 1, but assume that J&J Bagel makes payments at the beginning of each year.
4. Assume J&J Bagel takes out a bullet loan under the terms described. What are the payments on
the loan?
5. What are the payments for the interest-only loan?
6. Which mortgage is the best for the company? Are there any potential risks in this action?
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 10 images
- Izhar wants to buy a house in Taman Fulawa. The market price of the house is RM500,000. He is interested to get an Islamic home financing through Bank Hasan. There are two types of home financing offered which are Musyarakah Mutanaqisah and Al-Bay' Bithaman al-Ajil. For home financing of Musyarakah Mutanaqisah, the bank and client will share initial capital according to the ratio of 80:20. Profit-sharing ratio depends on the capital contribution. Monthly payment is RM3,000 where the bank's profit from the house rent in the first month is RM1,600. For home financing of al-Bay' Bithaman al-Ajil, the bank gets a profit of 65 percent. The financing tenure is 35 years. (a) Assume that Izhar chooses home financing through al-Bay' Bithaman al-Ajil. How much is the monthly payment that should be paid by Izhar? (b) Assume that Izhar chooses home financing through Musyarakah Mutanaqisah. Calculate the payment process that shows the increase in Izhar's ownership of the house for the first four…arrow_forwardJohn Snow has recently retired, and he received a large lump sum settlement from his employer. He would like to invest this money to achieve a stable long term income. He is considering investing in the following two companies: Allied Grocers (AG) are a 3-year-old online grocery retailer that specializes in delivering a wide selection of quality food products through an online platform. Beta Solutions (BS) is an established 10-year-old electronics company that is known for selling the most innovative electronic products and software solutions. Selected financial data for 2019 AG BS Average total assets 1,500,000 4,000,000 Average # of common shares outstanding (no preferred shares) 10,000 10,000 Dividends paid 10,000 50,000 Current Market price per share $95 $165 Net sales 1,300,000 6,300,000 Cost of goods sold 900,000 4,200,000 Gross profit 400,000 2,100,000 Operating Expenses: Administrative…arrow_forwardMr. Gumba is planning to take a SAM his new condo, which is valued at $220,000 for mortgage (loan) purposes. A SAM is written with the following characteristics. For the purpose of the calculation of the lender's share of appreciation only, the lending department used the following information (For others use the information given at the start of the problem): The lender has a claim to 50% of the price appreciation in the property anytime over the first 5 years, when the lender demands or when Mr. Gumba closes the loan (whichever is earlier). The property is currently valued for capital appreciation purposes by an appraiser for the bank at $180,000 and is expected to increase at a rate of 4.5% each year Other information on the loan: . LTV approved: 90% • Contract rate: 5% • Tenure: 30 years, monthly amortizing • Discount points: 1 ● Closing costs: $ 1000 If taken, Mr.Gumba plans to hold it only for five years, calculate the effective cost of borrowing for the holding period.arrow_forward
- The Jacksons are considering selling their current residence, buying a small home near Avery’s parents for $220,000 with a $100,000 30-year mortgage at 3.5%, and investing the net proceeds in their retirement accounts and education accounts. They assume they will incur 2% in transaction costs for the purchase and 6% for the sale. They have asked you the following: What will be their payment (principal and interest only) on their new home? How much will they be able to invest in their retirement accounts and education accounts after selling the old house and buying the new house? If the Jacksons purchase the new house one year from today, what will be the balance on their mortgage when they retire? What is the income tax consequence of their sale and purchase strategy?arrow_forwardThe Petersik family is considering purchasing a second home to use for short term rentals near the beach. If it purchases the house, they will place a down payment of $64,000 on the house. They estimate they will get an annual net rental profit of $8,500 after their mortgage and expenses are paid. After 18 years, they plan to pass the rental home along to their children, so assume the home has negligible salvage value. What would be the ERŘ if the Petersik family decides to invest in a rental home, assuming they keep the home for 18 years? Assume their MARR is 13%. Should the Petersik family invest in the rental home?arrow_forwardRansford and Alda Mariano own a home recently appraised for $426,500. The balance on their existing mortgage is $113,087. If their bank is willing to loan up to 80% of the appraised value, what is the amount of credit available to them (in $)? $arrow_forward
- Kash, Doll, and Tracy T are opening a new restaurant. They take out a 4.1%, 18-year, $250,000 mortgage on the building, but they do not have a lot of money because they are spending what they must to get the business started. In the future they intend to earn much more money from the success of the restaurant. Can they get a loan that will fit well with their current and future incomes? How much will they pay in interest for the loan? What are the monthly payments?arrow_forwardi need the answer quicklyarrow_forwardRonald and Samantha Brady recently had their condominium in Port Isaac appraised for $324,800. The balance on their existing first mortgage is $154,720. If their bank is willing to loan up to 75% of the appraised value, what is the amount (in $) of credit available to the Bradys on a home equity line of credit? $arrow_forward
- Two partners have decided to acquire a more extensivemanufacturing facility. One of the partners researched and found a factory selling for $25 million. The partners went to a local bank to discuss the mortgage options for the factory. The bank managers provided the following offers: Offer 1 30-Year Mortgage to be repaid in equal monthly installments No Closing costs 5.7% APR Offer 2 20-Year Mortgage to be repaid in equal monthly installments No Closing Costs Exact APR with the previous offer The following tasks are required: 1- What are the monthly payments for a 30-year traditionalmortgage? What are the payments for a 20-year traditionalmortgage? 2 - Prepare an amortization table for the first six months of thetraditional 30-year and 20-year traditional Mortgage. How much of the first payment goes toward the principal? How much is the total payment for the first six months for a 30-year and 20-year Traditional Mortgage?3- Which mortgage plan would you go with according to total…arrow_forwardPlease help solve this and please show all the steps to solve this step by step in Excel. Two years ago, Martin purchased a house for $100,000. Martin borrowed a mortgage with 80% of LTV (loan to value ratio). The interest rate on the mortgage is 6%. Payment terms are being made monthly to amortize the loan over 30 years. Martin has found another lender who will refinance the current outstanding loan balance plus all the costs associated with the new loan at 4.5% with monthly payments for 30 years. Suppose that the new lender will charge three discount points on the new loan and other refinancing costs will equal $3,000. What is the new loan amount if you choose to refinance? What is Martin's monthly payment for the new loan? What is the effective cost of Martin's new loan and do you refinance if he holds the loan for 30 years?arrow_forwardWhen Molly adds all of her payments, how much will the car cost her?arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education