chapter35

AUTO FILL/COPY1 22 5 - =B4FLAT PAYMENT SCHEDULESLoan principal 10,000Interest rate 7%Loan term 6 - Number of years over which loan is repaidAnnual payment 2,097.96 - =PMT(B3,B4,-B2)Split payment into:YearPrincipalat beginningof yearPayment atend of year InterestReturn ofprincipal1 10,000.00 2,097.96 700.00 1,397.962 8,602.04 2,097.96 602.14 1,495.823 7,106.23 2,097.96 497.44 1,600.524 5,505.70 2,097.96 385.40 1,712.565 3,793.15 2,097.96 265.52 1,832.446 1,960.71 2,097.96 137.25 1,960.717 0.00= $ B $ 3 *C 9= D 9 -E 9= C 9 -F 9A B C D E F G123456789101112131415等额偿还计划贷款本金 10,000利率 7%贷款期限 6 - 贷款还清所需年数年度还款额 2,097.96 - =PMT(B3,B4,-B2)还款额分解为:年 年初本金 年末本金 利息本金偿还额1 10,000.00 2,097.96 700.00 1,397.962 8,602.04 2,097.96 602.14 1,495.823 7,106.23 2,097.96 497.44 1,600.524 5,505.70 2,097.96 385.40 1,712.565 3,793.15 2,097.96 265.52 1,832.446 1,960.71 2,097.96 137.25 1,960.717 0.00= $ B $ 3 *C 9= D 9 -E 9= C 9 -F 9A B C D E F G123456789101112131415Income statementSales 31,235,689Cost of goods sold 15,250,888Sales, general and administrative 2,356,188Interest 1,999,824Profits before taxes 11,628,789Taxes 4,418,940Profits after taxes 7,209,849A B12345678损益表销售收入 31,236销售成本 15,251营业、财务、管理费用 2,356利息 2,000税前利润 11,629税费 4,419税后利润 7,210 - =B6-B7A B C12345678Income statementSales 31,236Cost of goods sold 15,251Sales, general and administrative 2,356Interest 2,000Profits before taxes 11,629Taxes 4,419Profits after taxes 7,210The cells retain their values 62,471,378 - =2*B2A B C12345678910损益表销售收入 31,236销售成本 15,251营业、财务、管理费用 2,356利息 2,000税前利润 11,629税费 4,419税后利润 7,210单元格的值不变 62,471,378 - =2*B2A B C12345678910