A Wall Street firm is trying to package nine mortgages for sale. The sizes of the mortgages (in thousands of dollars) are listed in the file P08_27.xlsx. To be sold, each package must consist of at least $1,000,000 in mortgages. What is the largest number of packages that can be created?

A Wall Street firm is trying to package nine mortgages for sale. The sizes of the mortgages (in thousands of dollars) are listed in the file P08_27.xlsx. To be sold, each package must consist of at least $1,000,000 in mortgages. What is the largest number of packages that can be created?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

If a car is sold for P1,230,000 and the bank requires 15% downpayment, what is the amount of the mortgage?
15. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You've decided to buy a house that is valued at $1 million. You have $300,000 to use as a down payment on the house, and want to take out a mortgage for the remainder of the purchase price. Your bank has approved your $700,000 mortgage, and is offering a standard 30-year mortgage at a 12% fixed nominal interest rate (called the loan's annual percentage rate or APR). Under this loan proposal, your mortgage payment will be per month. (Note: Round the final value of any interest rate in percentage form to four decimal places.) Your friends suggest that you take a 15-year mortgage, because a 30-year mortgage is too long and you will pay a lot of money on interest. If your bank approves a…
1a-c. Suppose we have a new type of MBS to accommodate the short-term investor. This new MBS security instrument contains only 5-year mortgages (in reality are rare if non-existent). ACME, a private secondary mortgage market, has pooled together ten $100,000 5-year mortgage loans. Note: To save space in writing out your work, you can scale the ten $100,000 to $100. Calculate the duration for this MBS pool assuming annual compounding for three years at 10 percent interest which a. is a “zero coupon”. b. is an interest-only MBS. c. is fully amortizable over the five years. 2. Now assume that the interest-only MBS in problem 2b. is prepayable (but not defaultable). Use the option-theoretic model to price this MBS. Interest rates have a 50% chance of going up 1% each year and a 50% chance of going down 1% each year. From your results, qualitatively compare the MBS value without prepayment to the MBS value with prepayment. Note: To save space in writing out your work, you can scale the ten…
You have located a warehouse property to purchase at a price of $320,000. You plan to make a 20% downpayment of $64,000. Interest rates are rising quickly, but you’ve managed to secure a fixed-rate commercial mortgage at 4.5%. Commercial mortgages are typically much shorter than consumer mortgages like home loans, so the lender has offered you a 10-year term. What is the total interest paid on this mortgage over the 10 year term?
Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You’ve decided to buy a house that is valued at $1 million. You have $200,000 to use as a down payment on the house, and want to take out a mortgage for the remainder of the purchase price. Your bank has approved your $800,000 mortgage, and is offering a standard 30-year mortgage at a 9% fixed nominal interest rate (called the loan’s annual percentage rate or APR). Under this loan proposal, your mortgage payment will be per month. (Note: Round the final value of any interest rate used to four decimal places.) Your friends suggest that you take a 15-year mortgage, because a 30-year mortgage is too long and you will pay a lot of money on interest. If your bank approves a 15-year, $800,000 loan at…
13. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You've decided to buy a house that is valued at $1 million. You have $100,000 to use as a down payment on the house, and want to take out a mortgage for the remainder of the purchase price. Your bank has approved your $900,000 mortgage, and is offering a standard 30-year mortgage at a 10% fixed nominal interest rate (called the loan's annual percentage rate or APR). Under this loan proposal, your mortgage payment will be per month. (Note: Round the final value of any interest rate used to four decimal places.) Your friends suggest that you take a 15-year mortgage, because a 30-year mortgage is too long and you will pay a lot of money on interest. If your bank approves a 15-year, $900,000…
You own a home that was recently appraised for $330,000. The balance on your existing mortgage is $117,450. If your bank is willing to loan up to 70% of the appraised value, what is the potential amount (in $) of credit available on a home equity loan?
The price of a condominium is $187,000. The bank requires a 5% down payment and one point at the time of closing. The cost of the condominium is financed with a 30-year fixed-rate mortgage at 6.5%. Use the following formula to determine the regular payment amount. Complete parts (a) through (e) below. PMT = a. Find the required down payment. $9350 b. Find the amount of the mortgage. $177650 c. How much must be paid for the one point at closing? $1776 (Round to the nearest dollar as needed.) d. Find the monthly payment (excluding escrowed taxes and insurance). More Enter your answer in each of the answer boxes. 11:12 PM O Type here to search 81°F Mostly cloudy 22 99+ 6/30/2021 DELL F3 F4 FS F6 F7 F8 F9 F10 F11 F12 PrtScr Insert Delete కలnn Home Num $4 %24 & Backspace 8. R T K Enter (凸)
You want to buy a $150,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan at 4.9% interest for the rest. The bank will charge 3 points on the amount financed. a) What is the amount of the down payment? b) How much is the loan amount going to be? c) What will be the amount charged for 3 points? *1 point is 1 % of the mortgage amount d) Find the amount of the monthly payment. (Do not add the cost of the points to the loan amount) Hint: click here Question Help: D Video Message instructor %24
A loan officer states, "Thousands of dollars can be saved by switching to a 15-year mortgage from a 30-year mortgage." Calculate the difference in required monthly payments on a 30-year mortgage loan at a rate of 3.5% vs. a 15-year mortgage at a rate of 3.0%. Assume both mortgages are for $100,000 and require monthly payments. Then, comment on what you notice and where do the "savings" come from?
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?
I can afford a $1500 per month mortgage payment. I found a 30 year loan at 6% interest. How big of a loan can I afford, how much total money will I pay the loan company, and how much of that money is interest?