I will upload the quiz questions on the day of the quiz as it is timed.

profileCaiden
sample.docx

6.1

Collection and NPV from the credit policy of 2/10, net 30 and 1% per month interest on all accounts after 30 days.

OLD POLICY

 

 

 

 

Collection within

10 days

30 days

60 days

90 days

Percentage

10%

30%

40%

20%

Discount/interest

-2%

0%

1%

1%

Collection

10%*(1-2%)

30%

40%+(40%*1%)

20%+(20%*1%*2)

 

0.098

0.3

0.404

0.204

Discount Rate

12%

pa

 

 

PV

0.098/(1+12%)^10/365

0.3/(1+12%)^30/365

.404/(1+12%)^60/365

.204/(1+12%)^90/365

 

0.0977

0.2972

0.3965

0.1984

NPV

0.0977+0.2972+0.3965+0.1984

 

0.9898

 

 

 

NEW POLICY

 

 

 

 

Collection within

10 days

30 days

60 days

90 days

Percentage

10%

50%

30%

10%

Discount/interest

-2%

0%

1.50%

1.50%

Collection

10%*(1-2%)

50%

30%+(30%*1.5%)

10%+(10%*1.5%*2)

 

0.098

0.5

0.3045

0.103

Discount Rate

12%

pa

 

 

PV

0.098/(1+12%)^10/365

0.5/(1+12%)^30/365

.3045/(1+12%)^60/365

.103/(1+12%)^90/365

 

0.0977

0.4954

0.2989

0.1002

NPV

0.0977+0.4954+0.2989+0.1002

 

0.9921

 

 

 

 

 

 

 

 

Yes, it should try the new policy

 

 

For calculating the NPV first the collections have to be determined after taking into account the discounts given on payment within 10 days and interest charged on payment made after 30 days.

After that, the discount rate considered by the company is 12%p.a and days in a year are assumed to be 365. So using this rate the present value of the collection is calculated and a sum total of the amount gives the Net Present Value. The same method applies for both, the old policy as well as the new credit policy.

Since the NPV of the new credit policy is higher the new credit policy should be implemented.

6.2

Cash Sale

 

Annual Sale

5

COGS

-3.2

NPV

1.8

Credit sale

 

 

 

 

 

Annual Sale

5*(1+25%)

 

 

 

 

 

6.25

 

 

 

 

 

Collection from Sale

 

 

30 days

60 days

90 days

Bad Debt

Total

 

6.25*20%

6.25*40%

6.25*37%

6.25*3%

 

 

1.25

2.5

2.3125

0.1875

6.25

Discount Rate

12%

pa

 

 

-4

PV

1.25/(1+12%)^30/365

2.5/(1+12%)^60/365

2.3125/(1+12%)^90/365

0

 

 

1.238

2.454

2.249

0.000

5.941

COGS

 

 

 

 

-4.000

NPV

 

 

 

 

1.941

After calculating the present value of cash flows from credit sale at a discounted rate of 12% with days in a year taken at 365 days is calculated.

Since the NPV of credit sale is higher than that of cash sale, Credit sale should be encouraged.

The minimum increase in sale to justify credit sale should be such that the NPV of Credit sale is at least equal to NPV of Cash Sale

NPV

1.800

COGS

4.000

PV of Sale

5.800

Credit sale

 

 

 

 

 

Annual Sale

5*(1+x%)

 

 

 

 

 

Collection from Sale

 

 

30 days

60 days

90 days

Bad Debt

 

 

5*(1+x%)*20%

5*(1+x%)*40%

5*(1+x%)*37%

5*(1+x%)*3%

 

 

 

 

 

 

 

Discount Rate

12%

Pa

 

 

 

PV=5.8=

5*(1+x%)*20%/(1+12%)^30/365

5*(1+x%)*40%/(1+12%)^60/365

5*(1+x%)*37%/(1+12%)^90/365

0

 

5.8=

5*(1+x%)*20%/(1+12%)^30/365+5*(1+x%)*40%/(1+12%)^60/365+5*(1+x%)*37%/(1+12%)^90/365

X=

15.92%

 

 

 

 

6.3

To calculate NPV for this decision we use the equation

NPV= (-C+(1-p)S + pRS ) * (1+r)

(1+r)^n (1+r)^m (p+r)

Putting the numbers, C = 800, p = .10, S = 1000, r = .0125, n = 1, R = .5, m = 3, we get

NPV= (-800+.9*1000 + .1*.5*1000 ) (1+.0125)

(1+.0125)^1 (1+.0125)^3 (.1+.0125)

=(-800+888.89+48.17)*9

=1234

As the NPV is positive Ashley can extend the credit to the customer.

6.4

The following equation to find the selling price of the portfolio,

NF + 12nB[(1 + r)−g/365 − 1] + mC(R r) − L + 12aNS

Selling price = P +

r (6.10)

In the above expression, a = 0, P = 0, N = 10,000, F = $25, m = 10,000, n = 10,000, C =

$1200, B = $800, R = .15, r = .08, g = 25 days, L = $100,000. Putting these numbers, we find the selling price as follows.

NPV =10‚000(25) + 12(10‚000)(800)[1.08−25/365 − 1] + 10‚000(1200)(.15 − .08) − 100‚000

.08

=3.971

Since the amount offered by Mellon Bank at $5 mn is higher than the NPV of $3.971 of credit card portfolio, First National Bank of Jermyn should accept the offer.