Num Sum
Log In
|
Create a FREE Account
|
Everyone's Spreadsheets
|
Tags
The comma separated values (CSV) data for spreadsheet:
'PNBB2' Investment Calculator
Just copy and paste it to where-ever you need it...
,Legacy ConSOLIDated Plans Inc.,,,,3 Year PNBB2 Plan,,,,, ,,,,,,,,,, Input here ->,,,250000,Input 'Amount' to consider Investing,,,,,, ,,Must be at least Php80\,000.00,,,,,,,, ,,,240000,'Nett Amount' to be Invested,,,,,, ,,*,60000,* This is the 'Initial Payment'\, which can be added to the 'Nett Amount' invested.,,,,,, ,,,300000,PNBB2 Investment Value,,,,,, ,The 'Pension Plan' has a 'Maturity Value' double the 'Investment Value'.,,,,,,,,, ,,,600000,,,,,,, ,The 'Terms' of the 'Buy Back' Agreement\, are as follows:-,,,,,,,,, ,i),,'Initial Payment',10% of 'Plan/Maturity Value',,,,,, ,,*,60000,"*20% of 'Investment Value' as 'up front' payment".,,,,,, ,ii),,'Installments',"90% 'Balance' paid 'Quarterly over 36 Months".,,,,,, ,,,45000,per Quarter (x 12),,,,,, ,,,540000,TOTAL RETURN,,,,,, ,This is a 'Return On Investment' (ROI) of:-,,,,,,,,, ,,ROI,1.25,,,,,,, ,Giving an 'Annual Percentage Rate' (APR) over that 36 Months of:-,,,,,,,,, ,,APR,0.4166666666666667,,,,,,, ,,,,,,,,,, Not a bad 'Return on Investment' with payments being via 12 x Quarterly PDC's (Post Dated Checks).,,,,,,,,,, If you want 'Capital Growth'\, rather than 'Income'\, re-investing over 36 Months\, to give Return over the following 36 Months\, can give some very impressive results.,,,,,,,,,, Assuming this 'PNBB2' product remains available for the full 36 Months\, and one is investing over Php280K\, then this can produce,,,,,,,,,, "10 x Your Money in 6 Years",,,,,,,,,, Click 'Here' for more 'Information',,,,,,,,,,
You can also
export the spreadsheet's formulas
instead of its calculated data.
Go back to spreadsheet:
'PNBB2' Investment Calculator
.
[ default color ]
recent: