Question: Please do it in excel and show excel formular A company has taken a steadily amortized loan of 3 250 000 The loan term is

Please do it in excel and show excel formular A company

Please do it in excel and show excel formular

A company has taken a steadily amortized loan of 3 250 000 The loan term is 8 years with quarterly payments. The interest rate of the loan is the Euribor 12-month rate 0,757% + margin of 1,2% -points. Calculate the sum of interests they need to pay during the whole loan term. Amount of loan Annual interest rate Payments in a year Loan term (in years) Relative interest rate Number of payments Amortization

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please do it in excel and show excel formular Fiona has taken an annuity loan The amount of loan she took was 150,000.00 The loan term is 18 years with monthly payments. The interest rate of the loan...

Please do it in excel and show excel formular Iris is planning to take an equal payment loan of 200 000 She can afford to pay 600 as a monthly payment. The interest rate is Euribor + 1.1% margin. The...

1. (35 points) You are a new employee of the Scannell Poultry Processing Company and as a part of your training, you are asked to determine the cost of equity capital (retained eamings) for the firm....

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

Hi, I need help completing this comparison analysis. I need to turn this in by Sunday 8/6. Created by EDGAR Online, Inc. UNDER ARMOUR, INC. Table_Of_Contents Form Type: 10-K Period End: Dec 31, 2013...

Dr.Ramsey Please assist me with my discussion post. Subject: Annuities Systematic risk evaluates the probability and extent of negative consequences to the larger body. For example, the government...

MULTIPLE CHOICE 1 Using the recurrence relation t0 = 8, tn+1 = tn + 9, the sixth term would be: A 2 15 B 17 C 23 D 53 E 62 A canoe costs $40 to hire for the first day and $30 for each extra day. If...

Need to complete 10 homework but now i need 5 homework then after some time 5 homework more. Here it is attachment. Chapter 5 HW Questions [ALL OF THESE MUST BE DONE IN EXCEL] 1. Future value: Chuck...

By about how much will g(x,y,z)=2x + x cos z-y sin 2 + y change if the point P(x,y,z) moves from Po(1-2,0) a distance of ds = 0.2 unit toward the point P(-1,0,2)? dgar (Type an integer or decimal...

The unadjusted trial balance and adjustment data of Elias Real Estate Appraisal Company at June 30, 2012, follow: Adjustment data at June 30, 2012: a. Prepaid insurance expired, $300. b. Accrued...

The accrual basis method of accounting can be best described as: a . The method that equates assets with liabilities and owners' equity. b . The recording of transactions and adjustments so that...

Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2016 are as follows: Cost Retail Beginning inventory $ 99,000 $ 189,000 Purchases...