Calculate your mortgage payment

Assignment Help Financial Management

Reference no: EM131564259

You must use the FINANCIAL FUNCTIONS in EXCEL to calculate your answers.

You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage.

1. Use function “PMT” to calculate your mortgage payment.

2. Use function “PV” to calculate the loan amount given a payment of $1500 per month. What is the most that you can borrow?

3. Use function “RATE” to calculate the interest rate given a payment of $1500 and a loan amount of $400,000.

Reference no: EM131564259

Questions Cloud

Determine the production level : MINIMIZING AVERAGE COST The total monthly cost (in dollars) incurred by Carlota Music in manufacturing x units of its Professional Series guitars is given.

A description of a human services program : Identifying sources of funding for a particular program is an essential part of resource development.

The predetermined overhead rate for the year was closest : Baker Corporation applies manufacturing overhead on the basis of direct labor-hours. The predetermined overhead rate for the year was closest to:

How marginal benefits and costs fit in to lukes decision : After viewing the video clip from Cool Hand Luke, first consider how marginal benefits and marginal costs fit in to Luke's decision?

Calculate your mortgage payment : Use function “PMT” to calculate your mortgage payment. Use function “RATE” to calculate the interest rate given a payment of $1500 and a loan amount of $400,000

Analyze the major cause of discrimination : Apply one or more of the theories of prejudice and discrimination (covered in Chapter 3 of the course text (Marger, 2015)) to analyze each example.

Find the worker efficiency : Ready-to-fly radio-controlled model airplanes t hr into the 8 a.m. to 12 noon morning shift . At what time during this shift is the average worker performing.

Derive the long-run demands for capital and labor : a. Derive the long-run demands for capital and labor. b. Derive the total cost curve for this firm.

Self-disclosure in various human and social services : Think about your current professional position or one you'd like to work in the future. Consider when you might and might not use self-disclosure.

User Account

All Pages