Question

In: Accounting

Problem 3 Ms. Lisa has recently joined PT KFC as staff in the finance team. Although...

Problem 3

Ms. Lisa has recently joined PT KFC as staff in the finance team. Although still relatively young, she is already very mature in managing her own financial matters. She has already developed a solid plan to cover for her long term financial needs. She is confident that by following her plan she will not be worried of her future financial condition during her old age.

Ms. Lisa borrowed $90,000 for her own business loan from her colleague and she must repay him at 4% annual rate of interest. She should repay her loan for the next 5 years. The loan is amortized into five equal, end-of-year payments.

  1. Calculate the annual, end-of-year loan payment.
  2. Prepare an amortization schedule showing the interest and principal breakdown of each loan payments.

Solutions

Expert Solution

Annual loan payment = Loan Amount/Present value annuity factor

= 90,000/PVAF(4%, 5 years)

= 90,000/4.451822

= $20,216.44

Amortization Schedule
Year Beginning Balance Interest Amount Annual payment Principal Repaid Closing Principal
1                90,000.00               3,600.00             20,216.44            16,616.44            73,383.56
2                73,383.56               2,935.34             20,216.44            17,281.10            56,102.46
3                56,102.46               2,244.10             20,216.44            17,972.34            38,130.12
4                38,130.12               1,525.20             20,216.44            18,691.24            19,438.89
5                19,438.89                  777.56             20,216.44            19,438.88                      0.00

Related Solutions

After graduating from QCCUNY, you recently joined as a staff accountant in the controller’s office at...
After graduating from QCCUNY, you recently joined as a staff accountant in the controller’s office at Klax Company that provides warehousing services for companies in several Midwestern cities. The location, Dubuque, Iowa, has not been performing well due to increased competition and loss of several customers that have recently gone out of business. Your controller suspect that the plant and equipment may be impaired and wonder those assets should be written down. Given the company’s prior success, this issue has...
Struggling with the bolded questions Matt Holmes recently joined Klax Company as a staff accountant in...
Struggling with the bolded questions Matt Holmes recently joined Klax Company as a staff accountant in the controller's office. Klax Company provides warehousing services for companies in several midwestern cities. The location in Dubuque, Iowa, has not been performing well due to increased competition and the loss of several customers that have recently gone out of business. Matt's department manager suspects that the plant and equipment may be impaired and wonders whether those assets should be written down. Given the...
Matt Holmes recently joined Klax Company as a staff accountant in the controller’s office. Klax Company...
Matt Holmes recently joined Klax Company as a staff accountant in the controller’s office. Klax Company provides warehousing services for companies in several European cities. The location in Koblenz, Germany, has not been performing well due to increased competition and the loss of several customers that have recently gone out of business. Matt’s department manager suspects that the plant and equipment may be impaired and wonders whether those assets should be written down. Given the company’s prior success, this issue...
Matt Jones recently joined Kind Company as a staff accountant in the controller's office. Kind Company...
Matt Jones recently joined Kind Company as a staff accountant in the controller's office. Kind Company provides warehousing services for companies in several East Coast cities. The location in Philadelphia, PA, has not been performing well due to increased competition and the loss of several customers that have recently gone out of business. Matt's department manager suspects that the plant and equipment may be impaired and wonders whether those assets should be written down. Given the company's prior success, this...
Ms. Goyal, after completing her graduation, recently joined a bank. With a steady income and good...
Ms. Goyal, after completing her graduation, recently joined a bank. With a steady income and good growth prospects for her career, she intends to save regularly and increase the amount of savings gradually over the years. Her colleagues in the bank have advised her investing in Mutual Funds (MFs), as a suitable option for her. However, Ms. Goyal is not at all familiar with MFs. Advise Ms.Goyal with the below queries: a. Explain brief on Mutual Funds and its features....
You have recently joined the international audit team at a large company responsible for janitorial work...
You have recently joined the international audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds. Steps/Questions 6. Analyze the Product Price column from each company using Benford’s Law. Analyze only the first digit of the column. On average, do nay of the vendors...
You have recently joined the international audit team at a large company responsible for janitorial work...
You have recently joined the international audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds. Steps/Questions 5. Verify the values in the Quantity and Total columns. Are any missing or abnormal values present?
Tommy has recently graduated from SUSS and has joined a well-known retailer that operates 3 department...
Tommy has recently graduated from SUSS and has joined a well-known retailer that operates 3 department stores in Singapore. His job function is that of a business analyst. It has been well-reported that retail business in Singapore is on the decline and his employer would like to determine if the forecast for the next few years will be equally bad. Tommy has been tasked to perform the analysis and his output will provide insights in the company's hiring and expansion...
This is the same Pt for all 3. 1. Pneumonia Pt , has no history of...
This is the same Pt for all 3. 1. Pneumonia Pt , has no history of DM , why is her serum glucose elveated? 2. Why is the same pt , have no fever? 3.Is there a sig probabilty that the patient got a UTI , that caused her pneumonia? She has urine incontinence and a clean urinealysis
Question 3: Mike has recently joined ‘MyBank’ as a security engineer. During his initial days, Mike’s...
Question 3: Mike has recently joined ‘MyBank’ as a security engineer. During his initial days, Mike’s line manager required him to observe the environment of the employees working in the head office. On his second day, Mike observed an employee using a USB stick into bank’s computer and his personal laptop back and forth. This situation concerned Mike… Answer the following: a. What makes Mike concerned? Discuss the implications of this security weakness on ‘MyBank’ in terms of the CIA...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT