Mann Co. is preparing an Excel spreadsheet for its 5-year, 6%, $400,000 installment notes. The notes were issued on January 1 for $421,236. Installment payments are payable each December 31. A portion of the spreadsheet appears as follows: A B C D E 1 Effective rate: 0.06 2 Cash payments: 100,000 3 Term to maturity in years: 5 4 5 Period Cash Payment Interest Expense Change in Balance Outstanding Balance 6 0 7 1 8 2 What formula should Mann use in cell E8 to calculate the outstanding balance (book value) of the notes after the second interest

Burke enterprises is considering a machine costing $30 billion that will result in initial after-tax cash savings of $3.7 billion at the end of the first year, and these savings will grow at a rate of 2 percent per year for 11 years. after 11 years, the company can sell the parts for $5 billion. burke has a target debt/equity ratio of 1.2, a beta of 1.79. you estimate that the return on the market is 7.5% and t-bills are currently yielding 2.5%. burke has two issuances of bonds outstanding. the first has 200,000 bonds trading at 98% of par, with coupons of 5%, face of $1000, and maturity of 5 years. the second has 500,000 bonds trading at par, with coupons of 7.5%, face of $1000, and maturity of 12 years. kate, the ceo, usually applies an adjustment factor to the discount rate of +2 for such highly innovative projects. should the company take on the project?