Question
Mini-Case PART A Owners of a new restaurant have found numerous costs associated with starting their business (see table). They financed the total of these
Mini-Case PART A Owners of a new restaurant have found numerous costs associated with starting their business (see table). They financed the total of these costs with end-of-month payments through a loan from the bank at {E} compounded {F}, amortized over {G} years.
1. What is the size of the monthly payments required to settle this loan?
2. What is the principal balance outstanding on the loan after one year?
3. What is the size of the final payment?
4. Construct a partial amortization schedule for this loan.
PART B
After two years in business, the owners have saved (have a surplus of) {H}. They must decide if they will invest in property or investment bonds.
If they invest in a property and a vehicle, the total cost will be {I}, of which {H} will be required as a down payment. The fixed interest rate on the mortgaged amount is {J} compounded {F} for a term of {K} years.
5. What is the size of the semi-annual payments required to settle this mortgage?
6. What is the size of the final payment?
7. How long would it take (in months) to settle this loan with regular monthly payments of exactly $2000 instead of the PMT value calculated in Part 5?
PART C
If the owners choose to invest in bonds instead, they look at a {L} bond set to mature in {M} years with a bond rate of {N}, payable semi-annually. The market rate is {J}, compounded semi-annually. The owners will only purchase the bond if they can afford it with their savings ({H}), and they can get the bond at a discount because they think the market rate will go down, potentially making the bond more valuable in the future.
8. If the bond rate is {N}, will the bond be sold at a premium or a discount? Explain your answer.
9. Calculate the purchase price of the bond if it is purchased today ({M} years before maturity).
10. Do the owners have enough money to buy their bond? Will they make the purchase?
| STUDENT ID (last 6 digits only) | ||
| Cost of Goods Sold | {A} | $35,000.00 |
| Equipment | {B} | $4,570.00 |
| Renovations | {C} | $1,000.00 |
| Other | {D} | $1,255.00 |
| Financing interest rate | {E} | 5.81% |
| Compounding periods per year (CY) | {F} | semi-annually |
| Length of amortization (years) | {G} | 9 |
| Savings/Surplus | {H} | $43,750.00 |
| Property and vehicle cost | {I} | $1,57,500.00 |
| Mortgage rate | {J} | 4.6% |
| Term of mortgage | {K} | 12 |
| Bond face value | {L} | $48,125.00 |
| Time until maturity | {M} | 8 |
| Bond rate | {N} | 1.2% |
| PAYMENT NUMBER | AMOUNT PAID | INTEREST PAID | PRINCIPAL REPAID | OUTSTANDING PRINCIPAL BALANCE |
| TOTALS: |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started