Day 5 spreadsheets

Day 5 spreadsheets - Entry 12/31/10 3/1/2010 65,000...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 706 Date Asset Flow 0 200,000 1 0 2 0 3 0 4 0 5 ### IRR 8.00%
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Installment note: $50,000 borrowed, 10 annual payments of $6,793, effective interest rate of 6%. 0 50,000 1 3,000 6,793 (3,793) 46,207 2 2,772 6,793 (4,021) 42,186 3 2,531 6,793 (4,262) 37,925 4 2,275 6,793 (4,518) 33,407 5 2,004 6,793 (4,789) 28,619 6 1,717 6,793 (5,076) 23,543 7 1,413 6,793 (5,380) 18,162 8 1,090 6,793 (5,703) 12,459 9 748 6,793 (6,045) 6,413 10 385 6,793 (6,408) 5 Date/Ti me Interes t Expens e Cash Flow Chang e in Carryin g Amoun t Carryin g Amoun t
Background image of page 2
Zero coupon note: $65,000 borrowed, $140,330 paidAssume zero coupon note issued on March 1, 2010. maturity (10 years), effective interest rate of 8%,
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Entry 12/31/10 3/1/2010 65,000 Interest expense 4,333 ### 5,200 0 5,200 70,200 Notes payable 4,333 ### 5,616 0 5,616 75,816 ### 6,065 0 6,065 81,881 Entry 2/28/11 ### 6,551 0 6,551 88,432 Interest expense 867 ### 7,075 0 7,075 95,506 Notes payable 867 ### 7,641 0 7,641 ### ### 8,252 0 8,252 ### Entry 12/31/11 ### 8,912 0 8,912 ### Interest expense 4,680 ### 9,625 0 9,625 ### Notes payable 4,680 ### 10,395 ### ### 0 Date/Tim e Interest Expens e Cash Flow Change in Carryin g Amount Carryin g Amoun t...
View Full Document

This note was uploaded on 03/03/2012 for the course MGMT 351 taught by Professor Staff during the Spring '08 term at Purdue.

Page1 / 3

Day 5 spreadsheets - Entry 12/31/10 3/1/2010 65,000...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online