Question: Develop a loan amortization schedule for a $3,000 loan at 56% interest rate per annum compounded weekly, repayable at the end of every week for

Develop a loan amortization schedule for a $3,000 loan at 56% interest rate per annum compounded weekly, repayable at the end of every week for 25 weeks. In addition, demonstrate your financial mathematical process by calculating the weekly instalment using the Financial Calculator and Microsoft Excel, clearly show all the steps involved.

Verify your answer using the appropriate Financial Calculator and the Microsoft Excel Spreadsheet Function to confirm that your manual calculations are accurate. You are required to show the relevant screenshots

Step by Step Solution

★★★★★

3.44 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Heres how you can manually calculate the weekly installment for a 3000 loan at a 56 annual interest ... View full answer

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 Finance Questions!

For each problem, show your work steps. A correct answer with no work shown gets half credit (which means you fail the assignment). An incorrect answer with no work receives 0 credit. With time value...

Consider the following optimization problem (P1). maximize 4x1 + 6x2 + 5x3+4x4 + 6x5 + 4x6 + 15x7 + 15x8 subject to 3x1 + 10x2 + 7x7 + 8x8 17, 5x1 + 2x2 + 4x7 + 3x8 7, 6x3 +9x4+x7 +10x8 13, 3x3 +...

Call Centre Case Study Calls R Us is a small call centre which provides customer services and sales for corporate clients. They are based in a converted warehouse in Melbournes outer Western suburbs...

You have just started a new job with a significant increase in salary above what you were earning when you originally negotiated your student loan repayment. The salary increase affords you the...

Question 3 [10] Mrs. Vilakazi is a farmer in Limpopo and a great businesswoman who is paying R1,000.00 per month on her savings annuity for and a 1/2 years(3.5) at an interest rate of 6% compounded...

Using the appropriate table, find the future value annuity factor for each of the following combinations of interest rate per period and number of payments: Number of Payments Interest Rate Per...

You are taking a $2000 loan. You will pay it back in four equal amounts, paid every 6 months starting 3 years from now. The interest rate is 6% compounded semiannually. Calculate: (a) The effective...

Today is June 7, 2007. Freddie Mac is issuing a 10-year Bermudan note on June 15 2007 under the terms described in Table 12.1410. A Bermudan security is like a callable security, but with call dates...

Hentzel Landscaping commenced its business on January 1, 20X1. 1. During its first year of operations, Hentzel purchased supplies in the amount of $12,000 (debited to Supplies inventory), and of this...

1.1. Miss X deposited R5000 in a saving account paying 3% Interest compounded daily. Find Future value of the money and interest she earned at the end of 2 years. (NB: NOT LEAP YEAR) (4) 1.2. What...

Question 2 lot yet nswered Match the various terminologies in the table below. Each correct match carries one mark Marked out of 5.00 Flog Question 1. Incremental Innovation A) Involves strategic...

Review Chapter 15, Table 15.4, Prisoner Dilemma . Suppose the game starts with both Jesse and Frank planning to "Stay Mum" in the lower right cell. Discuss how each player would evaluate the...

Question 78 of 81. The total amount of capital gain or loss that Allison must claim on her tax return is: ($1,985) ($1,515) $1,515 O $1,985

Can someone please help me with this, the lab seems easy but I keep messing it up, if you could help I would appreciate it, please You can even make numbers as longa as it follows the lab, I just...

Hardy Life Insurance Company intends to launch Revolution, a new enterprise management system, in its offices nationwide. The software includes human resource management, finance, and planning...

At December 31, 2023, Cord Company's plant asset and accumulated depreciation and amortization accounts had balances as follows: Category Land Land improvements Buildings Equipment Automobiles and...

Data from the financial statements of Dils Brothers Co. and J. Cox, Inc. are presented below (in millions): Dils Brothers Co. J. Cox, Inc. Total liabilities, 2016 $73,044 $54,196 Total liabilities,...

Ask students to outline the reasons why the various elements of culture (social structures and control systems, language and aesthetics, religion and other belief systems, educational systems, etc.)...

Russell (age 50) and Linda (age 45) Long have brought you the following information regarding their income and expenses for the current year. Russell owns and operates a landscaping business called...

Yolanda earns $112,000 in 2012. Calculate the FICA tax that must be paid by: Yolanda:.....................Soc.Sec..................$__________...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Let CP denote carcinogenic potential, TR test results, and FR field results. Suppose that for Figure 7.23 we have the following probabilities: Figure 7.23

How would you design an organization so that it could, in Tom Peterss (1998) words, thrive on chaos? What characteristics would such an organization have? What kind of people would you try to hire?...

Even though we distinguish between continuous and discrete uncertain quantities, in reality everything is discrete if only because of limitations inherent in our measuring devices. For example, we...