Results 1 to 5 of 5

Math Help - Can you guys help me with this business math problem?

  1. #1
    Newbie
    Joined
    Aug 2008
    Posts
    3

    Can you guys help me with this business math problem?

    Hey guys, our professor gave this as our final problem set for the semester but I don't really know how to do it or how to start. Any help would be very much appreciated

    Here it is:

    Mr. Go borrowed from Ms. Sy a certain amount payable at 9% compounded monthly after three years. Ms. Sy required Mr. Go to make regular payments of 9,000 pesos at the end of each month to settle his obligation. Everything went as agreed upon for a year. After the first year, however, Mr. Go missed remitting his monthly payments for five months. In order to make up for his missed payments, Mr. Go paid 60,000 pesos a month after the fifth month of missed payments and made regular installments of 9,000 pesos at the end of each month only for six months. After which he decided to pay Ms. Sy the rest of his loan through three quarterly payments of 40,000 pesos each.

    At the end of the three-year loan term, Ms. Sy claims that Mr. Go has not adequately paid the principal and all accumulated interests on the loan. Mr. Go, on the other hand, maintains that he has paid all his dues and has no obligation left unpaid. He adds that he, in fact, has paid more than he was supposed to.

    Show how much Mr. Go either still owes or has overpaid Ms. Sy (if any).


    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Aug 2008
    Posts
    3
    Anyone? Please..
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by jenn17sanders View Post
    Hey guys, our professor gave this as our final problem set for the semester but I don't really know how to do it or how to start. Any help would be very much appreciated

    Here it is:

    Mr. Go borrowed from Ms. Sy a certain amount payable at 9% compounded monthly after three years. Ms. Sy required Mr. Go to make regular payments of 9,000 pesos at the end of each month to settle his obligation. Everything went as agreed upon for a year. After the first year, however, Mr. Go missed remitting his monthly payments for five months. In order to make up for his missed payments, Mr. Go paid 60,000 pesos a month after the fifth month of missed payments and made regular installments of 9,000 pesos at the end of each month only for six months. After which he decided to pay Ms. Sy the rest of his loan through three quarterly payments of 40,000 pesos each.

    At the end of the three-year loan term, Ms. Sy claims that Mr. Go has not adequately paid the principal and all accumulated interests on the loan. Mr. Go, on the other hand, maintains that he has paid all his dues and has no obligation left unpaid. He adds that he, in fact, has paid more than he was supposed to.

    Show how much Mr. Go either still owes or has overpaid Ms. Sy (if any).

    First work out the principle of the loan p_0. Then set up a spreadsheet showing for the duration of the repayments, the final value will be the outstanding debt.

    Repayment of a loan of initial value p_0 over 36 months at 9% compounded monthly with monthly repayments of 9000 gives:

    \rho=1+0.09/12 = 1.0075

    p_0=9000\frac{1-\rho^{36}}{(1-\rho)\rho^{36}}\approx 283021.25

    Now set up a spreadsheet for the total duration of the actual repayment scheme showing the interest and payments.

    Also this is not entirely clear, how many payments of 60000 were there? I assume just one.

    He has overpaid by about 17000

    RonL
    Last edited by CaptainBlack; August 7th 2008 at 05:12 AM.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Member
    Joined
    Apr 2008
    Posts
    83
    Mr. Go borrowed from Ms. Sy a certain amount payable at 9% compounded monthly after three years. Ms. Sy required Mr. Go to make regular payments of 9,000 pesos at the end of each month to settle his obligation. Everything went as agreed upon for a year. After the first year, however, Mr. Go missed remitting his monthly payments for five months. In order to make up for his missed payments, Mr. Go paid 60,000 pesos a month after the fifth month of missed payments and made regular installments of 9,000 pesos at the end of each month only for six months. After which he decided to pay Ms. Sy the rest of his loan through three quarterly payments of 40,000 pesos each.

    At the end of the three-year loan term, Ms. Sy claims that Mr. Go has not adequately paid the principal and all accumulated interests on the loan. Mr. Go, on the other hand, maintains that he has paid all his dues and has no obligation left unpaid. He adds that he, in fact, has paid more than he was supposed to.

    Show how much Mr. Go either still owes or has overpaid Ms. Sy (if any).

    To find the outstanding loan balance, if any, at the end of 3 years, write an equation of value with the end of 3 years as the comparison date. Thus,
    Outstanding loan balance = (Future value of the loan amount) minus (Future value of the past payments)
    Accordingly, if Ms. Sy required Mr. Go to make regular payments of 9,000 pesos at the end of each month for 3 years payable at 9% compounded monthly, it is conceivable that the loan amount is
    9,000 \cdot \frac{{1 - \left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{ - \left( {3 \times 12} \right)} }}<br />
{{\tfrac{{.09}}<br />
{{12}}}}
    The future value of this loan amount at the end of 3 years is
    \left[ {9,000 \cdot \frac{{1 - \left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{ - \left( {3 \times 12} \right)} }}<br />
{{\tfrac{{.09}}<br />
{{12}}}}} \right] \cdot \left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {3 \times 12} \right)} <br />
    On the other hand, the future value of the past payments (or installment payments) is
    \left[ {9,000 \cdot \frac{{\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {1 \times 12} \right)}  - 1}}<br />
{{\tfrac{{.09}}<br />
{{12}}}}} \right] \cdot \left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {2 \times 12} \right)}  + 60,000\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {1.5 \times 12} \right)} <br />
     + \left[ {9,000 \cdot \frac{{\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {.5 \times 12} \right)}  - 1}}<br />
{{\tfrac{{.09}}<br />
{{12}}}}} \right] \cdot \left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {1 \times 12} \right)} <br />
     + 40,000\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {.75 \times 12} \right)}  + 40,000\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {.5 \times 12} \right)}  + 40,000\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {.25 \times 12} \right)} <br />
    I now leave the calculation in your hands to show for yourself if Mr. Go either still owes or has overpaid Ms. Sy (if any).
    If your calculation results in positive amount, then Mr. Go does still owes Ms. Sy.
    If your calculation results in negative amount, then Mr. Go has overpaid Ms. Sy and should be entitled to a refund.
    Think of it this way:
    If Ms. Sy decided to place the loan amount in a bank that pays 9% compounded monthly, she would be entitled to
    \left[ {9,000 \cdot \frac{{1 - \left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{ - \left( {3 \times 12} \right)} }}<br />
{{\tfrac{{.09}}<br />
{{12}}}}} \right] \cdot \left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {3 \times 12} \right)} <br />
at the end of 3 years.
    If Mr. Go decided instead to deposit his installment payments in bank that pays 9% compounded monthly rather than paying Ms. Sy directly, the value of his installment payments at the end of 3 years would be equal to
    \left[ {9,000 \cdot \frac{{\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {1 \times 12} \right)}  - 1}}<br />
{{\tfrac{{.09}}<br />
{{12}}}}} \right] \cdot \left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {2 \times 12} \right)}  + 60,000\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {1.5 \times 12} \right)} <br />
     + \left[ {9,000 \cdot \frac{{\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {.5 \times 12} \right)}  - 1}}<br />
{{\tfrac{{.09}}<br />
{{12}}}}} \right] \cdot \left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {1 \times 12} \right)} <br />
     + 40,000\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {.75 \times 12} \right)}  + 40,000\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {.5 \times 12} \right)}  + 40,000\left( {1 + \tfrac{{.09}}<br />
{{12}}} \right)^{\left( {.25 \times 12} \right)} <br />
    Check your results with the spreadsheet amortization schedule that Ive attached.
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Aug 2008
    Posts
    3
    THANK YOU SO MUCH for everything. Especially you jonah. You have no idea how much I appreciate the time you guys took to help me out. It gives me hope in humankind to know that there are still people like you who help complete stangers with their problems. Again, thank you so much
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Old guys arguin over math from long ago
    Posted in the Algebra Forum
    Replies: 4
    Last Post: September 9th 2011, 09:00 PM
  2. Story Problem - Business Math
    Posted in the Business Math Forum
    Replies: 1
    Last Post: March 16th 2010, 06:23 PM
  3. Replies: 2
    Last Post: February 15th 2010, 03:09 PM
  4. Business Math
    Posted in the Business Math Forum
    Replies: 0
    Last Post: April 18th 2008, 05:07 PM
  5. Business Math problem help
    Posted in the Business Math Forum
    Replies: 1
    Last Post: December 19th 2006, 07:02 AM

Search Tags


/mathhelpforum @mathhelpforum