The balance sheet of Veldt showed a balance in retained earnings of R5,872.4 at the end of 2013 and R4,640.9 at the end of 2012. Net income for the year was R2,362.5 million. All amounts are in millions of South African rand (R). Compute the amount of dividends declared during the year. Also can this be done in excel? If so what is the formula and how do you input the info? Not sure you can use excel...? Thanks