The MBA Decision

�� : ��

$

�� : �� & ��

$ $ $ $

�� : �� & ��

$ $ $ $

�� : �� (��) �� & ��

50,000.00 �� 3% �� 28 �� 35 �� 26%

2 60,000.00 2,500.00 95,000.00 15,000.00 4% 31%

��

1 75,000.00 3,500.00 78,000.00 10,000.00 3.5% 29%

��

��

��

6.50% $ $

3,000.00 �� 20,000.00 ��

�� : ��

$ 37,000.00 <�� =�3*(1��7) $ 728,896.23 <�� =(�36/(�27��4)*(1�(1+�4)��6/(1+�27)��6)) ��

�� & �� (��) �� & ��

$ $

�� 0 165,781.69 60,000.00 2,500.00 3,000.00 20,000.00 85,500.00 1.0000 165,781.69

��

$

68,341.82

�� (�� ) �� (�� )

$ 1,188,578.10

�� 1 60,000.00 2,500.00 3,000.00 20,000.00 85,500.00 0.9390

37000.00 0.9390 $

$

�� 2

<�� <�� <�� <�� <�� <�� <��

<�� =�53*(1+�4) <�� =1/(1+$�$27)��42 <�� =��(�53:�53,�54:�54)

10,350.00 0.8817

<�� =�14*(1��16) <�� =1/(1+$�$27)��42 <�� =��(�58:�58,�59:�59)

9,125.17

$ 1,179,452.93 $ 1,188,578.10

�� (�� )

$

=�11 =�12 =�29 =�30 =��(�44:�47) =1/(1+$�$27)��42 =��(�48:�48,�49:�49)

38110.00 0.8817

68,341.82

�� 2 ��

�� 3

65,550.00 <�� =�13*(1��16) 1,424,719.72 0.8278

954,454.59

<�� =(�62/(�27��15)*(1�(1+�15)�(�6��10)/(1+�27)�(�6��10)))

<�� =1/(1+$�$27)��42 <�� =��(�63:�63,�64:�64) <�� =�65+�60

��

�� & �� (��) �� & ��

$

$

�� 0 101,500.00 75,000.00 3,500.00 3,000.00 20,000.00 101,500.00 1.0000 101,500.00

��

$

34,741.78

�� (�� ) �� (�� )

$ 1,018,157.22

$

$

�� 1

�� 2

<�� =��(�79:�79,�80:�80)

37,000.00 0.9390

<�� =�36 <�� =1/(1+$�$27)��73 <�� =��(�84:�84,�85:�85)

7,100.00 0.9390

<�� =�23*(1��25) <�� =1/(1+$�$27)��73 <�� =��(�89:�89,�90:�90)

34,741.78

6,666.67

�� 1 ��

$ 1,011,490.56 $ 1,018,157.22

�� (��)

$

55,380.00 1,147,257.88 0.8817

881,915.44

�� 3

<�� =�22*(1��25) <�� =(�93/(�27��24)*(1�(1+�24)�(�6��19)/(1+�27)�(�6��19)))

<�� =1/(1+$�$27)��73 <�� =��(�94:�94,�95:�95) <�� =�96+�91

The MBA Decision

Recommend Documents