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

What is the main thing you can learn from an income statement?

balandron [24]

Your detailed expenses cost of sales and if the business made a profit or loss.

7 0

3 years ago

Read 2 more answers

Selected transactions for Thyme Advertising Company, Inc. are listed here Describe the effect of each transaction on assets, lia

Dima020 [189]

Answer:

1. Increased assets (Cash) – Increased stockholders’ equity (Common Stock)

2. Decreased stockholders’ equity (Rent Expense) - Decreased assets (Cash)

3. Increased assets (Cash) – Increased stockholders’ equity (Service revenue)

4. Increased assets (Accounts receivable) – Increased stockholders’ equity (Service revenue)

5. Decreased liabilities (Cash Dividends Payable) – Decreased assets (Cash)

6. Decreased stockholders’ equity (Advertising Expense) - Increased liabilities (Accounts payable)

7. Increased assets (Cash) – Decreased assets (Accounts receivable)

8. Increased assets (Equipment) – Decreased assets (Cash)

9. Increased assets (Equipment) – Increased liabilities (Accounts payable)

Explanation:

Accounting Equation Formula:

Assets = Liabilities + Owner's Equity

This equation tells us that Assets are increased by Debits and decreased by Credits, instead, Liabilities and Stockholders´ Equity decreased by Debits and increased by Credits. In the answer, Debits are represented by the left side of the note, and Credits by the right side of the note.

8 0

4 years ago

Cushman company had $814,000 in sales, sales discounts of $12,210, sales returns and allowances of $18,315, cost of goods sold o

lesya692 [45]

When solving for the gross profit on a product use:
Gross profit = Sales - Cost of goods sold

Sales = $814,000
Cost of goods sold = $386,650

Gross profit = $814,000 - $386,650
Gross profit = $445,350

3 0

3 years ago

Marla was faced with an ethical dilemma at work. Her long-time friend and colleague Josh was not performing at an acceptable lev

Ymorist [56]

Answer:

Is my approach professional and beneficial for the company?

Explanation:

Marla is facing an ethical dilemma best known as bias. As she has a personal relationship with Josh and has known him for a while now, she can't be purely objective when it comes to evaluating his performance. Even though she's pretty aware that his performance hasn't been up to the level required, their friendship might raise issues of value judgments. As her friend's supervisor, she needs to be as impartial, fair, transparent, and honest as possible. Her way to handle this situation will define her trustworthiness and loyalty towards the company and the other employees she's supervising.

4 0

4 years ago

Over the last two years, an american clothing company has partnered with a manufacturer in china to make clothes at a cheaper co

Trava [24]

The mutual benefit that the American Clothing Company derives by partnering with a Chinese Manufacturer comes because <u>E. It is</u> an example of counter-trading ...

<h3>What is Counter-trading?</h3>

Counter-trading occurs when goods or services are exchanged for other goods or services rather than for hard currency. It is a reciprocal form of international trade in which, for example, the American Clothing Company brings in its technology while the Chinese Manufacturer provides cheap labor and other resources.

<h3>Answer Options:</h3>

A. It is a strategic alliance in which two countries share the risks and rewards of starting a new enterprise together in a foreign country.

B. It is a wholly owned subsidiary in which a foreign subsidiary is totally owned and controlled by an organization.

C. It is a greenfield venture in which owning the organization has been built from scratch.

D. It is an example of a franchise in which a company allows a foreign company to pay it a fee and a share of the profit in return for using the first company’s brand name and a package of materials and services.

E. It is an example of counter-trading in which the country is bartering for goods.

Thus, the counter-trade between these companies is mutually beneficial because of <u>Option E</u>.

Learn more about counter-trading at brainly.com/question/14659049

6 0

3 years ago