|
|
|
Work out how much money has been lost on a property sale with the RATE function
Q A property that was bought for £345,950 four years ago has just sold for £259,500.
How can I calculate in Excel the total percentage loss in value and the
average loss each year?
James Wolseley
A If you wish to ignore the thousands frequently claimed by the government, solicitors, and estate agents when buying and selling, enter the purchase price in cell A3 and the sales price in B3.
In C3 enter the number of years. In D3 enter:
=RATE(C4,,-A4,B4)
The extra comma is needed because the normal second argument of the RATE function, a mortgage payment, doesn’t apply here.
In this example, the rounded results are that the property has lost 25 per cent of its value overall representing an average of seven per cent a year.
Article tags
Related articles
The error message a reader is getting is because he may have typed a space in the cell, which is confusing Excel when doing the spreadsheet calculations
It’s easy to hit the wrong key when using a PC and throw yourself into a panic. There's no need to worry - we have easy fixes for 30 common everyday errors
Microsoft Office and Open Office word processing and spreadsheet programs have simple ways of sorting lists of data in tables and spreadsheets
Q.Why can't my browser find the website address I typed...
Q.All updates have been downloaded, so why won't Windows...
Q.How do I stop Windows 7 search?
Be a money saving expert
Return of the Mac computer
The benefits of owning a smartphone
Choose Gold, Silver or Bronze membership
Save up to 40% on the cover price of each issue
Get access to the subscriber club exclusive website
Our price won't be beaten by any shop or website
|
|
|
|
|
Nikon Coolpix S570 BlackPrice: £66.99 |
Computeractive Ultimate Guide - Storage, Sharing & BackupPrice: £5.99 |
Back Issue CD-Rom 13 (2010)Price: £9.99 |
Hallmark Card Studio DeluxePrice: £15.31 |
Marine AquariumPrice: £15.41 |
