Use excel to calculate the initial payment

Assignment Help Financial Management

Reference no: EM131869279

Graduated payment problem. a. Use excel to calculate the initial payment of the following FHA GPM loan: $300,000, 30 years, 3%, monthly, 4 increases or steps (years 2, 3, 4, and 5-30) of 10% each. When I solve this problem I actually write the TVM formulas using parentheses and the exponential key ^. Use whatever method you like but remember it must work on excel with NO calculator assistance. It must solve for both loans. b. now change the loan to $430,000, 6%, 30 years, monthly, same step increases. Solve for new payment.

Reference no: EM131869279

Questions Cloud

Capital loss carryover is available to the estate : final return, $3,000 of his net capital loss can be deducted against ordinary income in year 20x1, and no capital loss carryover is available to the estate.

Identify the ethical culture problem : Based on the facts in the case and what you have learned in this chapter, evaluate the culture change effort that is under way.

Which projects should firm select if it has unlimited funds : Which projects should the firm select if it has unlimited funds?

Explain the states potential stance for rejecting policies : Explain the state's potential stance for rejecting each of the three federal policies or proposals .

Use excel to calculate the initial payment : Graduated payment problem. a. Use excel to calculate the initial payment of the following FHA GPM loan: $300,000, 30 years, 3%,

Was this a good contract for the thrall company to earn : What is the NPV of this Project? Was this a good contract for the Thrall Company to earn? Why or Why not?

The capped and uncapped lifetime interest rates : You need one or more if statements to get excel to choose between the capped and uncapped lifetime interest rates.

Identify significant changes that organization reasonably : They believe that you have considered what the organization does now, but how will your system adapt to new products and processes?

Analyze how theory of humanbecoming paradigm can be applied : Analyze how the Theory of Humanbecoming Paradigm can be applied to registered nursing practice versus advanced practice.

User Account

All Pages