Question

In: Finance

Classy Jewelry and More is talking with its bank about a $360,000 loan. The loan would...

Classy Jewelry and More is talking with its bank about a $360,000 loan. The loan would be for three years at 7% interest and Classy would make three LEVEL TOTAL PAYMENTS at the end of each of the next three years. Write an amorization schedule and answer the following questions.
What is the amount of the total payment?
What is the amount of the principal payment in year two?
What is the amount of the ending balance in year one?
What is the amount of the interest in year three?
What is the total amount of interest that will be paid over the life of the loan?

USE THE TABLES TO ANSWER THIS QUESTION.
Pam wants to buy her first home in five years. She will need $20,000 as a down payment. Pam just won some money gambling and she has deposited it into her savings account, which is earning 8% and compounds quarterly.
What table will you look at to solve this problem?
What column will you look at?
What row will you look at?
What is the factor?
How much will Pam have to set aside now out of her winnings to have the $20,000 in five years?

Amelia's Antiques just added a whole new line of furniture to the product line. Amelia expects this addiition to result in record high dividends of $5.25 and $5.50 in the next two years. After that, she thinks that her growth will level off at its usual 3% rate. The rate expected in the marketplace for investments similar to Amelia's is 6%.
What is the current value of a share of Amelia's Antiques?
What will be the value of a share of Amelia's in five years?
What will be the value of a share of Amelia's in eighteen years?

Solutions

Expert Solution

We can use excel to determine the level total payments or calculate it manually. In excel we will make use of the PMT function and the formula will be: PMT(7%, 3, 360000). This will give a value of $137,178.60.

Manually we can use the following equation: level payment = [(P*R)*(1+R)^n]/[(1+R)^n – 1]

= [(360000*7%*(1.07^3)]/[1.07^3 – 1]

= 30,871.08/0.225043

= $137,178.60

Now we can make the amortization schedule as shown below:

Year Loan balance at start of year Payment Interest Principal Loan balance at end of year
0      360,000.00
1              360,000.00    137,178.60    25,200.00    111,978.60      248,021.40
2              248,021.40    137,178.60    17,361.50    119,817.10      128,204.30
3              128,204.30    137,178.60      8,974.30    128,204.30                   0.00

Amount of total payment = 137,178.60*3 = 411,535.80

Amount of principal payment in year 2 = $119,817.10

Amount of ending balance in year 1 = $248,021.40

Amount of interest in year 3 = $8,974.30

Total interest paid over the life of loan = 25200 + 17361.50 + 8974.30 = $51,535.80

The formulas used can be seen in the image below:


Related Solutions

Besides the financial and strategic (market) objectives, more and more companies are now talking about the...
Besides the financial and strategic (market) objectives, more and more companies are now talking about the social objectives as the goals of a company. What are your opinions on this?
You are about to ask the bank for a loan for $ 5,000 at a compound...
You are about to ask the bank for a loan for $ 5,000 at a compound annual interest rate of 9% with a monthly capitalization. You are asked to make five semiannual payments and that the first payment be made at the end of the first semester. For each semester, calculate the interest payment and the principal payment.
Sprint would like to investigate if women average more minutes per month talking on their cell...
Sprint would like to investigate if women average more minutes per month talking on their cell phones than men. The following data show the number of minutes per month that a random sample of men and women talked on their cellular telephones, analyzed at alpha = 0.05. Test if the average number of minutes used by women exceeds the average number of minutes used by men. t-Test: Two-Sample Assuming Unequal Variances Women Men Mean Women 461.1 Men 330.7 Variance        ...
Initial deposit --> university bank ---> loan --> bank #2. --loan--> bank #3---loan --> ($100).                         
Initial deposit --> university bank ---> loan --> bank #2. --loan--> bank #3---loan --> ($100).                                                Deposit--> Deposit--> Deposit--> a. What volume of loans can the banking system in the figure support? _____________ b. If the reserve requirement were 45 percent rather than 75 percent, what would the system’s lending capacity be?  ____________
if you were an investor or a bank about to give a loan to an organization,...
if you were an investor or a bank about to give a loan to an organization, how would you determine if their financial statements were accurately portraying their finances? What is a step an investor can do to ensure accuracy of the reported financial status?
we are talking about the mc68000 microprocessor a) Explain possible scenarios that would set the V...
we are talking about the mc68000 microprocessor a) Explain possible scenarios that would set the V bit of the Status Register in signed number arithmetic operations b) Name 3 Internal Bus and explain their usage and functionality in a microcontroller c) Explain how the displacement is calculated and how the PC gets updated when branching to a subroutine using BSR instruction d) Why do we use MOVEQ or ADDQ instead of MOVE or ADD instruction? (Explain with an example)
A company is trying to structure a loan with the Bank of California. The company would...
A company is trying to structure a loan with the Bank of California. The company would like to purchase a property for $2.5 million. The property is projected to produce a first-year NOI of $200,000. Loan: The lender will allow an 80 percent LTV loan on the property. It also requires a DCR in the first year of at 1.25. The contract (or the accrual) rate of interest on the loan is 12 percent. The lender is willing to allow...
A bank wants to evaluate which credit card would be more attractive to its customers, one...
A bank wants to evaluate which credit card would be more attractive to its customers, one with a high interest rate for unpaid balances but no annual fee or one with a low interest rate for unpaid balances for an annual fee of $50. Foe a random sample of 100 of its 52,000 customers, 40 said they prefer the one that has an annual fee. Would you conclude statistically that more people prefer the card with no annual fee? Test...
The bank statement of Ricardo's Jewelry shows a balance of $7,689.23. The bank charged a service...
The bank statement of Ricardo's Jewelry shows a balance of $7,689.23. The bank charged a service fee of $15.00. The account register shows deposits of $824.66 and $1,231.65 that do not appear on the statement. Four checks recorded in the register did not clear the bank by the end of the month. These were written for $18.65; $95.00; $122.36; and $55.98. The register is showing a balance of $9,468.55. What is the reconciled balance of this account?
4) If you were the bank loan officer would you recommend renewing the loan or demand...
4) If you were the bank loan officer would you recommend renewing the loan or demand its repayment? Would your actions be influenced if, in early Year 2, Computron (the company) showed you its projection plus proof that it was going to raise over $1.2 million of new equity capital? PS: Year 2 data is estimation. Year 2 Year 1 Year 0 Industry Current Ratio 1,86x 1,1x 2,3x 2,7x Quick Ratio 0,67x 0,4x 0,8x 1,0x Inventory turnover 4,10x 4,5x 4,8x...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT