Explain understanding of the excel pmt function in project

Assignment Help Accounting Basics
Reference no: EM132688371

Use a bank's special mortgage rate of 2.16% (that isthe annual percentage rate and will not change over the amortization period). Calculate the total interest amount paid at the end of amortization terms. Calculate monthly interest payment and monthly principal payment for each options.
The project must be completed on an Excel worksheet. The worksheet needs to contain variable data such as monthly payment, constants such as interest rate, and calculations using proper Excel functions. Use cell references (absolute, relative or mixed references) appropriately and include all formulas.

In order to obtain full marks, your worksheet needs to satisfy the evaluation criteria:

  1. Presentable layout of your worksheet
  2. Use of Excel Functions
  3. Reflective summary: use the two given questions as a guide when writing up your project reflections.

Question 1: Explain your understanding of the Excel PMT function in this project.

Question 2: What were your three strategies in order to complete the project?

Reference no: EM132688371

Questions Cloud

Role of health education in health promotion programs : Explain the role of health education in health promotion programs.
What are some emerging issues in leadership : What are some emerging issues in leadership? Discuss some alternatives to leadership. (support your claims/arguments with key research findings)
What sources of power have now emerged for nurses : What sources of power have now emerged for nurses in your organization and in the nation? How should nurses and nursing leaders at all levels continue to.
What steps are today organisations taking to promote : What steps are today's organisations taking to promote diversity and are these efforts effective? (support your arguments with key research findings)
Explain understanding of the excel pmt function in project : What were your three strategies in order to complete the project? Explain your understanding of the Excel PMT function in this project.
Discuss about the measures of central tendency : Search the GCU Library and find one new health care article that uses quantitative research. Do not use an article from a previous assignment, or that appears.
Calculate what monthly payments would be : You are a financial consultant and need to provide information, Calculate what his monthly payments would be if the loan was amortized over the 10 years
Impact on proper placement and treatment planning : Describe in detail the 6 assessment dimensions of the ASAM patient placement criteria. Discuss their impact on proper placement and treatment planning.
What way proof of lodgement documents filed : In what way proof of lodgement documents filed so that they are easily accessible and traceable? Explain in detail and provide the specific example.

Reviews

Write a Review

Accounting Basics Questions & Answers

  What nonfinancial factors if any should managers consider

What nonfinancial factors, if any, should managers consider in making investment decisions? Which of these nonfinancial factors are most important, and why?

  Why is stockholder equity section an important consideration

Why is the stockholders' equity section of the balance sheet an important consideration in analyzing the performance of a company?

  Paid-in capital-excess of par increase for transaction

Montgomery & Co., a well established law firm, provided 500 hours of its time to Fink Corporation in exchange for 1,000 shares of Fink's $5 par common stock. Mitchell's usual billing rate is $700 per hour, and Fink's stock has a book value of $250..

  Road ready tire co manufactures automobile tires standard

road ready tire co. manufactures automobile tires. standard cost and actual costs for direct materials direct labor and

  What was the original estimated life of the machine

On 1/1/16 Volcano sold the machine for $40,000. A gain of $20,000 was recorded. What was the original estimated life of the machine

  Determine the predetermined overhead rate

In December 2010, Perez Company established its predetermined overhead rate for jobs produced during year 2011 by using the following cost predictions.

  What is the maximum CCA

Assuming that the opening UCC for Class U assets is $0, what is the maximum CCA that can be deducted for this machine in the fiscal year 2020

  Show how these events affect the balance sheet

Show how these events affect the balance sheet, income statement, and statement of cash flows by recording them in a horizontal financial statements model

  Prepare a CVP income statement for the quarter ended March

Radial Inc. had sales of $2,400,000 for the first quarter of 2014. Prepare a CVP income statement for the quarter ended March 31, 2014

  At what settle price will you get a demand for funds

You enter into a futures contract to sell €125,000 at $1.51 per euro. At what settle price will you get a demand for additional funds

  Prepare journal entries to adjust books of williams company

Accrued salaries and wages are $18,000 at December 31, 2013. Prepare journal entries to adjust the books of Williams Company at December 31, 2013

  What is the acid-test ratio for the current year

What is the acid-test ratio for the current year? What is the book value per share of common stock for the current year?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd