All categories

3 years ago

Compounding

Business

1 answer:

r-ruslan [8.4K]3 years ago

6 0

Answer:

Task A:

<u>What is the effecting annual rate changed on this loan?</u>

Answer is 3.03%

<u>What would be the quarterly payment on this loan?</u>

Answer is $5,403.06

<u>Dr. Zoidberg also discovers that instead of the special promotional rate he can make an additional down payment of $20,000 that would lower his loan amount accordingly (i.e. by $20,000). At what APR would Dr. Zoidberg have the same quarterly payment with this option as with the initial promotional rate of 3%?</u>

Answer is 12.21%

<u>Dr. Zoidberg finds that he can get 1.5% APR if he elects option (c). What will his quarterly payment be under this option?</u>

The answer is $4,159.37

<u>Now assume that that payment frequency changes to annual, preserving the same EAR. What is his payment now?</u>

The answer is $21,835.46

Explanation:

<h2>Task A: </h2><h3>What is the effecting annual rate changed on this loan?</h3>

Solution:

Effective annual rate = (1 + (APR/n))ⁿ - 1

where

n = number of compounding periods per year = 4 (compounding quarterly)

APR = 3%

Effective annual rate = (1 + (3%/4))⁴ - 1

Effective annual rate = 3.03% (answer).

<h2>Task B: </h2><h3>What would be the quarterly payment on this loan?</h3>

Solution:

Quarterly loan payment is calculated using PMT function in Excel :

Rate = 3% / 4 (converting annual rate into Quarterly rate)

nper = 5*4 (5 year loan with 12 Quarterly payments each year)

pv = 100000 (loan amount)

PMT Formula = PMT(3%/4,5*4,100000)

PMT is calculated to be $5,403.06 (answer)

Note: PMT calculation has been attached.

<h2>Task C:</h2><h3>Dr. Zoidberg also discovers that instead of the special promotional rate he can make an additional down payment of $20,000 that would lower his loan amount accordingly (i.e. by $20,000). At what APR would Dr. Zoidberg have the same quarterly payment with this option as with the initial promotional rate of 3%?</h3>

Solution

The quarterly rate to have the same quarterly payment is calculated using RATE function in Excel :

nper = 5*4 (5 year loan with 12 Quarterly payments each year)

pmt = -5403.06 (Quarterly payment. This is entered with a negative sign because it is a payment)

pv = 80000 (loan amount)

RATE is calculated to be 3.05%. This is the quarterly rate. To get APR, we multiply by 4.

Formula for APR = RATE(5*4,C1,80000)*4

APR = 12.21% (answer)

<h2>Task D</h2><h3>Dr. Zoidberg finds that he can get 1.5% APR if he elects option (c). What will his quarterly payment be under this option?</h3>

Solution:

Quarterly loan payment is calculated using PMT function in Excel :

rate = 1.5% / 4 (converting annual rate into Quarterly rate)

nper = 5*4 (5 year loan with 12 Quarterly payments each year)

pv = 80000 (loan amount)

PMT formula: PMT(1.5%/4,5*4,80000)

PMT is calculated to be $4,159.37

<h2>Task E</h2><h3>Now assume that that payment frequency changes to annual, preserving the same EAR. What is his payment now?</h3>

Solution:

PMT = PMT(3%,5,100000)

PMT = $21,835.46

You might be interested in

Cost of goods sold is characterized by the following statements

melamori03 [73]

Answer:

The interpretation of the particular context is provided in the subsection below on clarification.

Explanation:

The cost of the products sold has become a reporting liability on either the cash flow statement.
The cost of the goods offered for sale includes the cost of materials expenditures and the time to prepare such a component for selling price.
The cost of the goods generated is measured using gross profit. Prices of the products sold are also known as selling costs.

4 0

3 years ago

Meyer Inc's total invested capital is $610,000, and its total debt outstanding is $185,000. The new CFO wants to establish a tot

valentinak56 [21]

Answer:

b. $150,500

Explanation:

debit/capital = $185000/$610000

= 30%

target debt is 55%

debt/capital = 0.55

let the new debt be Y

Y/$610,000 = 0.55

Y = $335,500

excess debt need by company = $335500 - $185000

= $150500

Therefore, The debt that the company must add to achieve the target debt to capital ratio is $150500.

5 0

4 years ago

With a organizational structure groups that are performing similar tasks may be at risk of duplicating their work and they may a

Nataly [62]

With a organizational structure groups that are performing similar tasks may be at risk of duplicating their work and they may also compete for shared resources is in the divisional structure.

In a divisional structure, many teams work alongside each other toward a single, common goal. Each of these divisions has an executive manager who manages how that branch operates, controls its budgets and allocates its resources.

Large companies do generally employ divisional structure because they have different divisions.

One example of the divisional structure is a car company which separates its company into SUV or sedan vehicle branches. While each branch has its own function, they all work toward the same goal of making a sale. This is known as the multi-divisional structure.

To know more about divisional structure here:

brainly.com/question/27337527

#SPJ4

3 0

2 years ago

Alpha Computing is a U.S. company that specializes in IT research. It has formed a joint venture with Microchips Inc., a Belgium

Airida [17]

Answer:

The answer is: Strategic alliance

Explanation:

Strategic alliance refers to an agreement between two or more companies that will work together to pursue common goals or objectives. Each company will remain independent and their collaboration is solely to achieve a specific common objective. In this case, Alpha and Microchips will continue to work independently and will work together as one only in China.

8 0

4 years ago

Why is drinking water an infrastructure of development?justify

faust18 [17]

Water is good for your health

Hope that help correct me if im wrong

4 0

3 years ago

Read 2 more answers