分红表格式范本excel(文件交接表格式范本)

?o?????oé?‘?????????51èˉ?????|?????”¨EXCEL????????????è????’è′|???

???????‰?|????????????????è????’è′|???

è???°±é?è|??”¨??°excel?o??????…?????￥???è|??′???????????—￥???????oé?‘????????????é?‘é￠????????????é￠????′ˉè????????é?‘é￠????′ˉè???????????é￠????13??????????????????”?????????????”???????????′ˉè????‰???1′??–?”?????????

1. ???????—￥????????3?‰￡????—￥???????|?a?2018/12/20a???
2. ??oé?‘?????????oé?‘?”3è′-??·???????ˉ???a?o¤??“?—￥????????oé?‘?…?????…??????

?3¨???????|??????oé?‘????o￠?????oé?‘??????????é?????è???—??°±è|??ˉ1è?¨????¤?????o???è??é????‘???é??è?¤é‰????o￠?????????èμ?????‰??￥????o￠??????é￠?????¤??o???

?¤???o?¤??°‘???é￠??‘￠???????o￠?o”??—?????°é?‘?…??”3è′-è′1é?¤??￥??“?¤???oé?‘????????????????????‰1000?????oé?‘?????oé?‘????1.1?…??????èμ??o§??ˉ1000*1.1=1100?…?????oé?‘?…????????o￠????ˉ????????o￠0.1?…????????o￠????????oé?‘??????ˉ1.1-0.1=1?…????????o￠??￠??????é￠?1000*0.1/1=100????????3???…±??‰1100?????oé?‘?????èμ??o§??????è????ˉ1100*1=1100?…???

3.??????é?‘é￠??????3?‰￡???é?‘é￠???é?¤?o??ˉ???????????????-é”?????”?????“???é?‘é￠??1???ˉ??￥???è????￥??

4.?????????é￠??????????é?‘é￠?/??oé?‘????????o?o??–1?????ˉ??￥???????”3è′-è′1?‰￡é?¤???|?????‰￡é?¤?”3è′-è′1????????????é￠?=??????é?‘é￠?/???1+?”3è′-è′1?????‰/??oé?‘??????

5.?′ˉè????????é?‘é￠?????‰??‰??????é?‘é￠??1??’?

6.?′ˉè???????????é￠?????‰??‰?????????é￠??1??’?

7.?13?????????????′ˉè????????é?‘é￠?/?′ˉè???????????é￠?

8.???????”????????????oé?‘????-?13???????????‰*?′ˉè???????????é￠?????–???????-?′ˉè????????é?‘é￠????”¨???è…é??·?????????a????????a???????????=??oé?‘????*?′ˉè???????????é￠???

9.???????”???????????′ˉè????‰??????????”????/?′ˉè????????é?‘é￠???

10.?1′??–?”??????????è?è?‘???????—?é—′????′?????1′??–?”???????è????—?…??????¨excelè?¨è?“?…￥?????°=POWER???1+???????”??????????1/?·2???????1′?????°??‰-1.

???è?°?1′??–?”??????????è????—?–1?3?è?????è?è?‘?o???????????—?é—′????′????????2???‰è?è?‘èμ?é?‘?????????|????????ˉ???”??????èμ?é?‘????—?é—′??·???’?é?‘é￠???·??????—?????…￥è?è?‘????°±è|??”¨XIRR??￥è????—?o????????a????-??????????????—￥???????????é?‘é￠????èμ?é?‘?μ???o????¤o-????‰?’???“?‰???oé?‘????????èμ?é?‘?μ??…￥????¤o+????‰????????—??o??3??ˉè????—?1′??–?”????????????′???????

????o???‰???????????–?-–??￥????μ???—

??‘?????￥?ˉ?????2a?·±300??o?????????è?????2016?1′1?????????§????????????￥????“a?§??-–??￥??′?￥????

1.?????????é￠????èμ?

??ˉ??￥?????°?????a?-￠??°2018?1′1???????????????…￥24000?…????èμ???—7913?…?????′ˉè???”???????33.0%????1′???14.7%???”¨XIRRè????—????1′??–?”?????????o29.87%??

2.?￥é?????|???????

?”±?o??????o?¤??o?é??è????‘?????????????μ??o??2???‰è·???′è??10%????‰??￥????-???¨?￠??????

3.??·???13????-–??￥

è?è?‘??°é?è′§è?¨è??’??????o??…??¨?￠?é??????′??????±?“???????è??????§???oé?‘??????￠????1000?…?????ˉ??????????￠????é￠???o????￠?é??1%????ˉ??￥?????°?????a?-￠2018?1′1???????????????…￥21595?…????èμ???—7516?…?????′ˉè???”???????34.8%????1′??–15.4???|?????”¨XIRR?3???￥??—???èˉ??????·???13????-–??￥?1′??–?”?????????ˉ??￥è????°30.03%??

1??‰???1??a?????oé?‘??????￠????1000?…???????2??a?????oé?‘??????￠????1000*???1+1%??‰=1010?…??????????2??a??????????????=1000+1010=2010?…??????￥?-¤?±???¨

2??‰??“????????=???????′ˉè???????????é￠?*??“?????oé?‘????

3??‰??????é?‘é￠?=???????????-??“???????????è′?????￡è?¨èμ????

4??‰?°???????é—′??‘?”?èμ???????????′ˉè???”???????=?′ˉè???”????/???¤§????…￥???é?‘??????è‰2é?¨?????‰

é?è???’??????????é￠????èμ??ˉ1?ˉ”???????”???????èˉ′?????·???13????-–??￥?ˉ”?????????é￠???′??‰??????????????′??“?”???????????????????é￠?èμ???—?¤????????o??·???13????-–??￥??′é????é??è???????