document.write( "Question 195176: Hi Iam haveing some trouble with my financial homework, would someone please help me.
\n" );
document.write( "My question is : Johm borrows $150,000. The terms of the loan are 7.5% over the next 5 years. It it important to note that he makes annual rather than monthly payments. Construct a loan amortization schedule that shows the 5 payments of Johns loans.\r
\n" );
document.write( "\n" );
document.write( "Iwould like to thank you in advance for your help and useing your time to help me with this question. \n" );
document.write( "
Algebra.Com's Answer #146385 by solver91311(24713)![]() ![]() You can put this solution on YOUR website! \r \n" ); document.write( "\n" ); document.write( "The payment (using the PMT function in Excel) is $37,074.71\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "You should be able to construct your own amortization table using that information:\r \n" ); document.write( "\n" ); document.write( "Row 1 would be:\r \n" ); document.write( "\n" ); document.write( "Beginning principal: 150,000 \n" ); document.write( "Interest accrued: 150,000 X .075 \n" ); document.write( "Principal + Interest: Add the first two amounts \n" ); document.write( "Less the payment of $37,074.71 gives the starting principal for the next year \n" ); document.write( "The payment minus the interest accrued is the amount applied to the principal, if you need that.\r \n" ); document.write( " \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "John \n" ); document.write( " \n" ); document.write( " \n" ); document.write( " |