<![CDATA[
<P> <A name="[문서의 처음]"></A></P>
<P style="FONT-SIZE: 15px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 23px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 15px; COLOR: #000000; LINE-HEIGHT: 23px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">* 재무함수</SPAN> </P>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><A name=#7191e807></A></SPAN>
<TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=62 cellSpacing=0 cellPadding=0 width=623 border=1>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=303 height=62>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">FV(이율, 기간, 월납입액, 납입시점)</SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"></SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"></SPAN> </P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=320 height=62>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">일정금액을 정기적으로 불입하고 일정한 이율을 적용하는 투자의 미래가치의 계산</SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">납입시점 : 1은 월초, 0 또는 생략하면 월말</SPAN></P></TD></TR></TBODY></TABLE><SPAN></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px 0px 0px 20px; COLOR: #000000; TEXT-INDENT: -20px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">- 연이율 6%로 2년 만기저축을 매월 말 40,000원씩 저축, 복리이자율로 계산하여 만기에 찾을 수 있는 금액은?</SPAN> </P>
<P style="FONT-SIZE: 13px; MARGIN: 0px 0px 0px 20px; COLOR: #000000; TEXT-INDENT: -20px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><BR></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><A name=#7191e808></A></SPAN>
<TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=43 cellSpacing=0 cellPadding=0 width=623 border=1>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=306 height=43>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">PV(이율, 기간, 지급액, 미래가치, 납입시점)</SPAN><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN>
<P style="FONT-SIZE: 13px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN> </P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=316 height=43>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">투자액의 현재가치 계산</SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">납입시점 : 1은 월초, 0 또는 생략하면 월말</SPAN></P></TD></TR></TBODY></TABLE><SPAN></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px 0px 0px 20px; COLOR: #000000; TEXT-INDENT: -20px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">- 10년 간 매달 말에 100,000원을 지급하는 연금보험의 보험가격이 8,000,000원이고, 연이율이 7%일 경우 이 연금 보험을 구입하는 것은 유리한 투자로 볼 수 있는가?</SPAN> </P>
<P style="FONT-SIZE: 13px; MARGIN: 0px 0px 0px 20px; COLOR: #000000; TEXT-INDENT: -20px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">- 자동차 구입금 중 잔금 2,000,000원을 4년 간 매월 초 50,000원씩 갚아나가는 것과 일시불 현금으로 지불하는 것 중 어떤 방법이 유리하다고 볼 수 있는가? 단, 연이율은 6%이다.</SPAN> </P>
<P style="FONT-SIZE: 13px; MARGIN: 0px 0px 0px 20px; COLOR: #000000; TEXT-INDENT: -20px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><BR></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><A name=#7191e809></A></SPAN>
<TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=62 cellSpacing=0 cellPadding=0 width=623 border=1>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=303 height=62>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">NPV(할인율, 금액1, 금액2, ...)</SPAN><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN> </P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=320 height=62>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">할인율가 앞으로 지출과 수입을 사용하여 투자의 현재가치를 계산</SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">결과가 0보다 클 때 투자가치가 있음.</SPAN></P></TD></TR></TBODY></TABLE><SPAN></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px 0px 0px 20px; COLOR: #000000; TEXT-INDENT: -20px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">- 오늘부터 1년 후 1,000,000원을 투자하고, 앞으로 3년 동안 300,000, 420,000, 680,000원의 연간수입을 얻고, 연할인율이 10%로 가정할 때 이 투자의 순현재가치는 얼마인가?</SPAN> </P>
<P style="FONT-SIZE: 13px; MARGIN: 0px 0px 0px 20px; COLOR: #000000; TEXT-INDENT: -20px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><BR></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><A name=#7191e80a></A></SPAN>
<TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=104 cellSpacing=0 cellPadding=0 width=623 border=1>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=303 height=104>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">PMT(이율, 기간, 현재가치, 미래가치, 납입시점)</SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">월상환액 + 이자율</SPAN><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN> </P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=320 height=104>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">정기적으로 불입하고 일정한 이율이 적용되는 대출에 대해 매회 불입액을 계산</SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">현재가치 : 대출금</SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">미래가치 : 최종 불입 후 잔금, 생략하면 0</SPAN>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">납입시점 : 1은 월초, 0 또는 생략하면 월말</SPAN></P></TD></TR></TBODY></TABLE><SPAN></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px 0px 0px 20px; COLOR: #000000; TEXT-INDENT: -20px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">- 1,000,000원을 1년 간 대출할 때 연 7%의 이자율이 적용된다면 매월 말 상환해야 할 불입액은 얼마인가?</SPAN> </P>
<P style="FONT-SIZE: 13px; MARGIN: 0px 0px 0px 20px; COLOR: #000000; TEXT-INDENT: -20px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><BR></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><A name=#7191e80b></A></SPAN>
<TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=150 cellSpacing=0 cellPadding=0 width=623 border=1>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=303 height=43>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">PPMT(이율, 상환회차, 상환기간, 현재가치, 미래가치, 상환시점)</SPAN><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=320 height=43>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">정기적으로 불입하고 일정한 이율이 적용되는 대출금에 대한 주어진 기간동안의 원금상환액을 계산</SPAN></P></TD></TR>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=303 height=43>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">IPMT(이율, 상환회차, 총상환기간, 대출원금, 최종상환후 잔금, 상환시점)</SPAN><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=320 height=43>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">정기적으로 불입하고 일정한 이율이 적용되는 대출금에 대한 주어진 기간동안의 이자상환액을 계산</SPAN></P></TD></TR>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=303 height=25>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">SIN(자산취득원가, 잔존가치, 내용년수)</SPAN><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=320 height=25>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">단위기간동안의 자산의 감가상환액을 정액법으로 계산</SPAN><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD></TR>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=303 height=40>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">DB(자산취득원가, 잔존가치, 내용년수, 감가상각기간, 첫해사용개월수)</SPAN><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=320 height=40>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">정율법을 사용하여 지정된 상각기간의 감가상각액을 계산</SPAN><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD></TR></TBODY></TABLE><SPAN></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><BR></SPAN></P>
<P style="FONT-SIZE: 15px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 23px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 15px; COLOR: #000000; LINE-HEIGHT: 23px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">* 정보함수</SPAN> </P>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><A name=#7191e80c></A></SPAN>
<TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=66 cellSpacing=0 cellPadding=0 width=623 border=1>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=303 height=23>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">ISBLANK(인수)</SPAN></P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=320 height=23>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">인수로 주어진 셀이 빈 셀이면 TRUE 출력</SPAN></P></TD></TR>
<TR>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=303 height=43>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">ISERROR(인수)</SPAN></P></TD>
<TD style="BORDER-RIGHT: #000000 0.12mm solid; BORDER-TOP: #000000 0.12mm solid; BORDER-LEFT: #000000 0.12mm solid; BORDER-BOTTOM: #000000 0.12mm solid" vAlign=center width=320 height=43>
<P style="FONT-SIZE: 12px; MARGIN: 0px 7px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">인수로 주어진 셀이 오류값(#N/A, #VALUE!, #REF, #DVO/O!)을 가지고 있으면 TRUE 출력</SPAN></P></TD></TR></TBODY></TABLE><SPAN><A name=#7191e80d></A>
<IMG height=49 src="file:///C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/UNI0004.gif" width=65 border=0></SPAN> </P>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><A name=#7191e80e></A></SPAN>
<TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=42 cellSpacing=0 cellPadding=0 width=483 border=1>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: #000000 0.1mm; BORDER-TOP: #000000 0.1mm; BORDER-LEFT: #000000 0.1mm; BORDER-BOTTOM: #000000 0.1mm" vAlign=center width=253 height=21>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">=ISBLANK(A1) 결과값 : FALSE</SPAN><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD>
<TD style="BORDER-RIGHT: #000000 0.1mm; BORDER-TOP: #000000 0.1mm; BORDER-LEFT: #000000 0.1mm; BORDER-BOTTOM: #000000 0.1mm" vAlign=center width=230 height=21>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">=ISBLANK(A4) 결과값 : TRUE</SPAN><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD></TR>
<TR>
<TD style="BORDER-RIGHT: #000000 0.1mm; BORDER-TOP: #000000 0.1mm; BORDER-LEFT: #000000 0.1mm; BORDER-BOTTOM: #000000 0.1mm" vAlign=center width=253 height=21>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">=ISERROR(A1) 결과값 : FALSE </SPAN><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD>
<TD style="BORDER-RIGHT: #000000 0.1mm; BORDER-TOP: #000000 0.1mm; BORDER-LEFT: #000000 0.1mm; BORDER-BOTTOM: #000000 0.1mm" vAlign=center width=230 height=21>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify">=ISERROR(A2) 결과값 : TRUE</SPAN><SPAN style="FONT-SIZE: 13px; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한양신명조'; TEXT-ALIGN: justify"></SPAN></P></TD></TR></TBODY></TABLE><SPAN></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 21px; FONT-FAMILY: '굴림'; TEXT-ALIGN: justify"></P>
<!-- -->
]]>
카페 게시글
컴활용능력
컴활1급━※
재무 정보함수 정리
왕두목™
추천 0
조회 4,035
08.05.05 10:33
댓글 21
다음검색
첫댓글 좋은 게시물이네요. 스크랩 해갈게요~^^
좋은 게시물이네요. 스크랩 해갈게요~^^
제가 공부하다 막혔던부분인데 넘 좋은자료 감사합니다^^
좋은 게시물이네요. 스크랩 해갈게요~^^
좋은 게시물이네요. 스크랩 해갈게요~^^
함수에서 물어 보고 싶은게 있는데요----0<=x<10 ---의 함수는 어떤게 하나요??? 그리고 이 범위의 갯수를 하고 싶은때는 함수가 뭐지줘 ---아시는분 부탁해요
좋은 게시물이네요. 스크랩 해갈게요~^^
좋은 게시물이네요. 스크랩 해갈게요~^^
감사 드립니다...........
원본 게시글에 꼬리말 인사를 남깁니다.
1번 답안 작성좀 해주시면 안될까요..ㅠ_ㅠ.. FV(0.06/12, 2*12, 40000, 0) 이거 맞나요? 그리고 월불입액 다음에 "현재가치"인가 입력안하면 0으로 계산한다던..그건뭔지욤..??-_-
자격증 쉽고 재밌게 따자! 무료 동영상 강의 ★ http://edu.zz.io ★
좋은 게시물이네요. 스크랩 해갈게요~^^
좋은 게시물이네요. 스크랩 해갈게요~^^
좋은 게시물이네요. 스크랩 해갈게요~^^
원본 게시글에 꼬리말 인사를 남깁니다.
좋은 게시물이네요. 스크랩 해갈게요~^^
좋은 게시물이네요. 스크랩 해갈게요~^^
전 마지막 그림이 않보여요..--;;
좋은 게시물이네요. 스크랩 해갈게요~^^
감사합니다~~