Podcast
Questions and Answers
Mr. and Mrs. ______ have out grown their 1,000 sq.ft. apartment they rented when they got married.
Mr. and Mrs. ______ have out grown their 1,000 sq.ft. apartment they rented when they got married.
Peterson
The Petersons have a combined annual gross ______ of $250,000.
The Petersons have a combined annual gross ______ of $250,000.
income
Their combined student loan plus a car loan ______ will be $1,200 a month for the next five years.
Their combined student loan plus a car loan ______ will be $1,200 a month for the next five years.
payment
The Petersons have saved $275,000 to use for a down ______ and/or an investment portfolio.
The Petersons have saved $275,000 to use for a down ______ and/or an investment portfolio.
The average annual property tax and homeowner’s insurance ______ expenses run around 4.0 percent of the value of the house.
The average annual property tax and homeowner’s insurance ______ expenses run around 4.0 percent of the value of the house.
They were told that they could borrow a maximum of $766,550 at 8.75% with a 30-year ______.
They were told that they could borrow a maximum of $766,550 at 8.75% with a 30-year ______.
If they want to make a lower down payment (but not less than ______%) they would have to pay an extra 125 bps for mortgage insurance for the life of the loan.
If they want to make a lower down payment (but not less than ______%) they would have to pay an extra 125 bps for mortgage insurance for the life of the loan.
New Jersey homeowners paid an average property tax bill of ______%
New Jersey homeowners paid an average property tax bill of ______%
If they put less than 20% down with the minimum down payment of ______%, they also must pay an extra 1.5% for mortgage insurance for the life of the loan.
If they put less than 20% down with the minimum down payment of ______%, they also must pay an extra 1.5% for mortgage insurance for the life of the loan.
The ideal ______-to-income ratio is below 43% in order not to have any other excessive fees.
The ideal ______-to-income ratio is below 43% in order not to have any other excessive fees.
For either of the two fixed rate mortgages, the Petersons can pay up front one ______ (1% of the mortgage amount) and receive a reduction in the mortgage rate by 50-basis points (.50%).
For either of the two fixed rate mortgages, the Petersons can pay up front one ______ (1% of the mortgage amount) and receive a reduction in the mortgage rate by 50-basis points (.50%).
They could take out a ______-year mortgage with 100 basis points (1%) lower interest rate across the board.
They could take out a ______-year mortgage with 100 basis points (1%) lower interest rate across the board.
There are many assumptions about your clients (their financial status and ______) and the capital markets.
There are many assumptions about your clients (their financial status and ______) and the capital markets.
2 3 Fin 315 - Comprehensive Final Case 1 – Spring 2024 can help your clients by analyzing the ______ markets.
2 3 Fin 315 - Comprehensive Final Case 1 – Spring 2024 can help your clients by analyzing the ______ markets.
All Excel sheets must be in ONE excel file with five tabs – (1) Option 1, (2) Option 2, (3) Option 3, (4) What-if ______ analysis, and (5) Summary.
All Excel sheets must be in ONE excel file with five tabs – (1) Option 1, (2) Option 2, (3) Option 3, (4) What-if ______ analysis, and (5) Summary.
The template provides a structure for analyzing the costs of a 30 Year ______ or a 15 Year Mortgage.
The template provides a structure for analyzing the costs of a 30 Year ______ or a 15 Year Mortgage.
The table includes a column for the Loan Amount in ______.
The table includes a column for the Loan Amount in ______.
The total payment includes the PMT/Month, Property Taxes/Month, Mortgage insurance, and ______ expenses.
The total payment includes the PMT/Month, Property Taxes/Month, Mortgage insurance, and ______ expenses.
The condo has ______ service and the elevators require a key fob to keep non-residents from wandering around the building.
The condo has ______ service and the elevators require a key fob to keep non-residents from wandering around the building.
The condo rents for $3,000 a month including a $200 monthly ______ fee.
The condo rents for $3,000 a month including a $200 monthly ______ fee.
If you lease the property for a year, it comes with 1-month free rent upfront and you will pay the rent for only ______ months.
If you lease the property for a year, it comes with 1-month free rent upfront and you will pay the rent for only ______ months.
The rent will go up by ______% every year.
The rent will go up by ______% every year.
Housing prices have been increasing at about ______% to 8% annually.
Housing prices have been increasing at about ______% to 8% annually.
The condo has a fitness center and an outdoor pool that is located on the roof of the ______ floor.
The condo has a fitness center and an outdoor pool that is located on the roof of the ______ floor.
The Petersons have asked you to do a financial analysis of the three ______ presented above.
The Petersons have asked you to do a financial analysis of the three ______ presented above.
If the Petersons decide on the condo ______, how much will their current savings grow to in five years?
If the Petersons decide on the condo ______, how much will their current savings grow to in five years?
How much would a house like the two-housing ______ cost in five years?
How much would a house like the two-housing ______ cost in five years?
If the Petersons are in the 30% marginal tax ______, how would this fact alter your projections?
If the Petersons are in the 30% marginal tax ______, how would this fact alter your projections?
Every Excel sheet must be ______.
Every Excel sheet must be ______.
You must create an excel file with all calculations/equation/models are available for the instructor to ______.
You must create an excel file with all calculations/equation/models are available for the instructor to ______.
