Question

In: Finance

As a small software developer firm, you have approached the AXZ Bank to obtain a term...

As a small software developer firm, you have approached the AXZ Bank to obtain a term loan so that the firm can purchase a new server. The AXZ bank provides two (2) offers to your company, as listed below: a) a loan of $100,000 over a five (5) year period at an interest rate of 7.65% per annum (per year) payable at the end of each month. b) a loan of $100, 000 over a three (3) year period at an interest rate of 5.5% per annum (per year) payable at the end of each month. Requirements 1. Calculate the monthly loan instalments for each offer listed above – a) and b). 2. Calculate the total interest payments for each offer listed above – a) and b).

Solutions

Expert Solution

A

First option;:

Loan amount (PV)= 100000

Monthly rate (I)= 7.65%/12= 0.006375

Total months (n)= 5*12= 60

equal or annuity Payment formula = PV* i *((1+i)^n)/((1+i)^n-1)

100000*0.006375*((1+0.006375)^60)/(((1+0.006375)^60)-1)

=2010.930445

Monthly Payment would be $2010.93 in first option

Second option;:

Loan amount (PV)= 100000

Monthly rate (I)= 5.5%/12= 0.004583333333

Total months (n)= 3*12= 36

equal or annuity Payment formula = PV* i *((1+i)^n)/((1+i)^n-1)

100000*0.004583333333*((1+0.004583333333)^36)/(((1+0.004583333333)^36)-1)

=3019.59018

Monthly Payment would be $3019.59 in Second option.

B.

Interest paid under first option = (Monthly Payment * Number of Payment)-loan Amount

=(2010.93*60)-100000

=20655.8

Total ínterest Payment for a is 20655.8

Interest paid under second option = (Monthly Payment * Number of Payment)-loan Amount

=(3019.59*36)-100000

=8705.24

=Total ínterest Payment for b is 8705.24


Related Solutions

As a small software developer firm, you have approached the AXZ Bank to obtain a term...
As a small software developer firm, you have approached the AXZ Bank to obtain a term loan so that the firm can purchase a new server. The AXZ bank provides two (2) offers to your company, as listed below: a) a loan of $100,000 over a five (5) year period at an interest rate of 7.65% per annum (per year) payable at the end of each month. b) a loan of $100, 000 over a three (3) year period at...
You are a renowned software developer and you have been hired by an old British boyband...
You are a renowned software developer and you have been hired by an old British boyband that wants to make a comeback in the industry. They ask you to make an app to showcase their new music and events. In your implementation, you have a class for each of the 5 group members, but you find that compiling each band member’s class takes more time than you currently have. Luckily, you remember that you learned about Makefiles in your favorite...
RUN THIS PROGRAM ON NETBEANS As a Software Developer, you have received a requirement from a...
RUN THIS PROGRAM ON NETBEANS As a Software Developer, you have received a requirement from a Company to implement a prototype for its payroll system. You receive the following specifications: If an employee works more than its regular hours, it is considered overtime and it will be paid based on the employee’s experience. All employees are paid biweekly (80 hours) Employee taxes: 1% This company manages three categories of workers based on employee’s experience. Group 1 (Silver) o Pay rate:...
A small, private firm has approached you for advice on its capital structure decision. It is...
A small, private firm has approached you for advice on its capital structure decision. It is in the specialty retailing business, and it had earnings before interest and taxes last year of $ 500,000. The book value of equity is $1.5 million, but the estimated market value is $ 6 million. The firm has $ 1 million in debt outstanding, and paid an interest expense of $ 80,000 on the debt last year. (Based upon the interest coverage ratio, the...
A small, private firm has approached you for advice on its capital structure decision. It is...
A small, private firm has approached you for advice on its capital structure decision. It is in the specialty retailing business, and it had earnings before interest and taxes last year of $ 500,000. The book value of equity is $1.5 million, but the estimated market value is $ 6 million. The firm has $ 1 million in debt outstanding, and paid an interest expense of $ 80,000 on the debt last year. (Based upon the interest coverage ratio, the...
A small, private firm has approached you for advice on its capital structure decision. It is...
A small, private firm has approached you for advice on its capital structure decision. It is in the specialty retailing business, and it had earnings before interest and taxes last year of $ 500,000. The book value of equity is $1.5 million, but the estimated market value is $ 6 million. The firm has $ 1 million in debt outstanding, and paid an interest expense of $ 80,000 on the debt last year. (Based upon the interest coverage ratio, the...
Your firm has an average receipt size of $120. A bank has approached you concerning a...
Your firm has an average receipt size of $120. A bank has approached you concerning a lockbox service that will decrease your total collection time by two days. You typically receive 6,800 checks per day. The daily interest rate is .017 percent. The bank charges a lockbox fee of $170 per day. a. What is the NPV of accepting the lockbox agreement? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What would...
Your firm has an average receipt size of $145. A bank has approached you concerning a...
Your firm has an average receipt size of $145. A bank has approached you concerning a lockbox service that will decrease your total collection time by one day. You typically receive 7,100 checks per day. The daily interest rate is .017 percent. The bank charges a lockbox fee of $135 per day. What is the NPV of accepting the lockbox agreement? What would the net annual savings be if the service were adopted?
Consider you are a small business advisor. You have been approached by a client, John Stratton,...
Consider you are a small business advisor. You have been approached by a client, John Stratton, who is interested either in establishing a new electrical business, purchasing the existing Jim’s Electrical, or buying into the partnership of Jim and Wendy Burns. Your client wishes to make sure that he has obtained as much information as possible about the establishment of a new business before making any decisions. He requires advice from you about the steps he needs to take to...
Choice 1. You are the new software developer at work. You are brought into a meeting...
Choice 1. You are the new software developer at work. You are brought into a meeting with clients that do not understand the idea of sorting data. Now you know, that you cannot use complex math to explain, but you can illustrate in diagrams. Basically, this group has been working with unsorted data and you must explain why their searches and reports will be so much faster with sorted data. You do not know anything specific about their data, but...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT