Ank y approved a loan of 150000 at 45 apr compounded, Ask an Expert

Finance

ank Y approved a loan of $150,000 at 4.5% APR compounded quarterly for your new home purchase. Complete the Monthly Loan Payment Schedule in the space provided below. Be sure to fill up all the spaces.

*If you can explain how to get the payment size(especially), principal and interest payment, total monthly, quarterly payment(especially) I can do every month. This is supposed to be in an excel document, so if you know of easy formulas I can use please let me know. Thank you

Loan Amount $150,000 Loan Period 15 Years APR (%) 4.5%

Quarterly Payment_______ Total Interest___________ Total Payment__________

Payment No. Payment Size Principal Payment Interest Payment Total Monthly Payment Loan Balance

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92336173

Have any Question?Write your Review or question?

Related Questions in Financial Management

International financial management assignment -this

International Financial Management Assignment - This assignment consists of two parts, Part A and Part B. PART A - Assignment Question - As a recent graduate of Afin 867 you have been lucky enough to be offered a consult ...

Stress affects our food choices metabolism nutritional

Stress affects our food choices, metabolism, nutritional status, and overall health in many ways. For this discussion forum, we will be talking about how we cope with stress and how to optimize our coping strategies to b ...

Please respond to the following discussion not an essay

Please respond to the following: {Discussion, NOT an Essay. Under 350 WORDS} a) Propose three reforms to the investment markets that might reduce their exposure to systematic risk. Support your proposals with examples. b ...

Discuss the following select a company that has been in the

Discuss the following : Select a company that has been in the news for ethical violations (for example, Enron). Assess the following in 525 to 700 words: Identify the alleged ethical violations. Determine why the violati ...

Exercise benefits us in so many ways including improving

Exercise benefits us in so many ways, including: improving our physical and mental health; reducing our risk of cardiovascular disease; increasing our energy, stamina, strength, and agility; promoting better sleep; impro ...

Assignmentq1xyz company uses anbspperiodic inventory system

Assignment Q1. XYZ Company uses a periodic inventory system. The beginning balance of inventory and the purchases made by XYZ during the month of July are given below: Date Description Units Unit cost Total cost July 01 ...

Consider two companies united states steel x and facebook

Consider two companies: United States Steel (X) and Facebook (FB). Look at the profiles (financial statements for 2016) of each on yahoo finance and discuss the followings (you need to calculate these values yourself and ...

Discussion board unit the balance sheet - liabilitiesin

Discussion Board Unit: The Balance Sheet - Liabilities In 300-400 words, define and discuss the following: Estimated and contingent liabilities The difference between gross and net take home pay The difference between em ...

In the link below you will explore how companies compute

In the link below, you will explore how companies compute their cost of capital by computing a weighted average of the three major components of capital: debt, preferred stock, and common equity. The firm's cost of capit ...

Scenariobig data is everywhere and various businesses

Scenario Big Data is everywhere and various businesses around the world are driven by Big Data. However, while some businesses rely on Big Data for organizational decision making, this does not mean that the implications ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert