Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house. Lender guidelines suggest that the allowable monthly housing expenditure should be no more than 28 of monthly gross income. From this, you must subtract total nonmortgage housing expenses, which would include insurance and property taxes and any other additional expenses. This defines the affordable monthly mortgage payment. In addition, guidelines also suggest that total affordable monthly debt payments, including housing expenses, should not exceed 36% of gross monthly income. This is calculated by subtracting total nonmortgage housing expenses and any other installment debt, such as car loans, student loans, credit card debt, and so on, from 36% of total monthly gross income. The smaller of the affordabl monthly mortgage payment and the total affordable monthly debt payments is the affordable monthly mortgage. To calculate the maximum that can be borrowed, find the monthly payment per $1,000 mortgage based on the current interest rate and duration of the loan. Divide the affordable monthly mortgage amount by this monthly payment to find the affordable mortgage. Assuming a 20% down payment, the maximum price of a house would be the affordable mortgage divided by 0.8. Use the following data to test your model: Total monthly gross income = $7,000 Nonmortgage housing expenses $350 Monthly installment debt = $400 Monthly payment per $1,000 mortgage = $7.75 Enter the formulas for the spreadsheet that implements this model. 1 Total Monthly Gross Income 2 Allowable Monthly Housing Expenditure B D $7,000.00 Max Percentage 0.28 $350.00 3 Total Non-Mortgage Housing Expenses 4 Affordable Monthly Mortgage Payment 5 Monthly Installment Debt $400.00 6 Total Affordable Monthly Debt Payments Max Percentage 0.36 7 Affordable Monthly Mortgage 8 Monthly Payment per $1000 mortgage $7.75 9 Maximum that can be borrowed 10 Down Payment 11 What one can afford to spend on a house 20%

Q: nothing is there

A: Capital deduction rate for Trinidad and Tobago for buildings and improvements, motor vehicles, heavy…

Q: Why would it

A: Internal Control:   Internal control refers to the policies, and plans of the business organization…

Q: Solution is totally wrong

A:

Q: nonrecurring

A: Extraordinary things vs. Nonrecurring Items: an summaryExtraordinary things area unit gains or…

Q: Req C is incorrect.

A: Equivalent unit of production is multiplied by cost per equivalent unit to compute the assignment of…

Q: Explain preemptive right

A: Answer: A pre-emptive right is a benefit that can be granted to other owners in a company that gives…

Q: Explanation 1031 like-kind exchange

A:

Q: Why is a preemptive right important?

A: Preemptive rights means the rights to  be offered to purchase a property before it is offered to…

Q: what is disinvestment ?

A: Disinvestment:  Disinvestment means selling off the assets such as manufacturing plant, a division,…

Q: What are some motives for divestitures?

A: The question is based on the concept of divestiture strategy, which is used by company to overcome…

Q: Which are the disadvantage of a C corp?

A: C corporation is the corporation that is taxed separately from its owners or shareholders.  In other…

Q: What is an Anti-dilutive Security

A: Anti-dilutive securities are those securities that a company has issued and which can get converted…

Q: Under Tier 2 Mudaraba: The Mudarib contributes only managment. a. TRUE b. FALSE

A: Tier 2 Mudaraba : This is a pre Islamic Arabic type of finance under which one individual provides…

Q: Define the following relative to like-kind exchanges: Boot Postponed gain or loss Gain or loss…

A: The like kind exchange is defined as the transaction of tax deferred which allows for asset disposal…

Q: What Constitutes a Discontinued Operation?

A: Income statement: The financial statement which reports revenues and expenses from business…

Q: All of these say incorrect.

A: An expense that benefits more than one product and for which the contribution to each product cannot…

Q: utio

A: In general, a "eligible rollover distribution" is any payment paid in a lump sum or over a period of…

Q: why would using a single WACC not be appropriate for valuing an LBO?

A: Leveraged Buyout (LBO) It is an acquisition in which the primary source of consideration is debt.…

Q: Example of someone use a derivative

A: Derivatives: These are the financial instrument, which derives their value from the price and the…

Q: When are loss contingencies recorded?

A: Definition:   Contingent liability: This is an uncertain obligation which might be incurred on a…

Q: why would it not be option A

A: The T1 personal tax return is the tax return form required to be filed by all taxpayers in Canada.…

Q: answer to that problem is zero?

A: Accured liabilities and the liabilities which need to prepare within 1 year and the said  to be…

Q: Give two examples of errors of commission?

A: Accounting error: Accounting errors can be defined as omission of the fundamental accounting…

Q: Not sure

A: Formulas: Minimum stock price = Face value / Convertible shares

Q: These are wrong except for net position restricted

A: Net position is the position which has been determined to the government so that the position of the…

Q: Why does the exclusion of the preemptive right ordinarily inconsequential?

A: Preemptive Rights: It is a contractual clause that gives the shareholders right or allows them to…

Q: What is an uncorrected misstatement?

A: Auditing:   Auditing refers to an independent examination of financial information of any…

Q: Wrong Answer

A: The cost of purchase is $1800 on October 23. It can be done using one of the two credit cards a)…

Q: Compare the Mutually Exclusive Alternatives, based on IRR?

A: The internal rate of return (IRR) is a capital budgeting metric used to gauge the benefit of…