January 2, 2023

My Investments Update – January 2023

Nick Investing crowdfunding, events, reviews, property 4 Comments

Happy New Year! Here is my latest monthly update about my investments. You can read my December 2022 Investments Update here if you like

I’ll begin as usual with my Nutmeg Stocks and Shares ISA. This is the largest investment I hold other than my Bestinvest SIPP (personal pension), from which I recently started withdrawing again.

As the screenshot below of performance over the last year shows, my main Nutmeg portfolio is currently valued at £19,898. Last month it stood at £20,391 so that is a fall of £493.

Apart from my main portfolio, I also have a second, smaller pot using Nutmeg’s Smart Alpha option. This is now worth £3,023 compared with £3,114 a month ago, a decrease of £91.

Here is a screen capture showing performance over the last year. As you can see from the ochre line, I topped up this account in February 2022.

That is a net month-on-month decrease of £584. That is obviously disappointing, but needs to be set against an increase of £785 the month before.

As the charts above clearly illustrate, 2022 was a volatile year for stock market investments generally. The outlook is still uncertain, but according to this article in the Financial Times the majority view is that stock markets overall will remain flat or see a very modest recovery in 2023. But obviously a lot depends on world events. If the war in Ukraine ends and/or China makes a reasonably smooth recovery from the pandemic, things could improve faster. Probably the best strategy, as this article from Forbes puts it, is to hope for the best but be prepared for the worst!

Overall, my Nutmeg investments are down £2,191 or about 8.7% since the start of 2022. To put this in context, though, in 2021 they rose in value by £3,552. And I am still more than £5,600 ahead since I started investing with Nutmeg in 2016. For my main portfolio that represents a return on capital of 39.01% or 57.13% time-weighted. My Smart Alpha portfolio hasn’t been going as long, but it is at least showing a small profit on the total I have put into it 🙂

Of course, the main lesson from all this is that investing is (or should be) a long-term endeavour. Over a period of years stock market investments such as those used by Nutmeg typically produce better returns than cash accounts, often by substantial margins. But there are never any guarantees, and in in the short to medium term at least, losses are always possible.

You can read my full Nutmeg review here (including a special offer at the end for PAS readers). If you are looking for a home for your annual ISA allowance, based on my overall experience over the last six years, they are certainly worth considering.

Moving on, my Assetz Exchange investments continue to generate good returns. Regular readers will know that this is a P2P property investment platform focusing on lower-risk properties (e.g. sheltered housing). I put an initial £100 into this in mid-February 2021 and another £400 in April. In June 2021 I added another £500, bringing my total investment up to £1,000.

Since I opened my account, my AE portfolio has generated a very respectable £91.61 in revenue from rental income. Capital growth has stalled, though, in line with what is happening in housing markets more generally. While some of ‘my’ properties are still showing gains, others are showing losses on capital. Overall my portfolio is currently showing a small net decrease in value of £7.88.

The latter is obviously a little disappointing, although of course capital values are largely academic unless and until you want to sell. The rental income is still coming in steadily without any issues or dramas. As I’ve said before, £91.61 is a decent rate of return on my £1,000 and does illustrate the value of P2P property investments for diversifying your portfolio when equity markets are volatile. And it doesn’t hurt that with Assetz Exchange most projects are socially beneficial as well.

To control risk with all my property crowdfunding investments nowadays, I invest relatively modest amounts in individual projects. This is a particular attraction of AE as far as i am concerned. You can actually invest from as little as 80p per property if you really want to proceed cautiously.

My investment on Assetz Exchange is in the form of an IFISA so there won’t be any tax to pay on profits, dividends or capital gains. I’ve been impressed by my experiences with Assetz Exchange and the returns generated so far, and intend to continue investing with them. You can read my full review of Assetz Exchange here. You can also sign up for an account on Assetz Exchange directly via this link [affiliate].

Another property platform I have investments with is Kuflink. They continue to do well, with new projects launching almost every day. I currently have around £2,400 invested with them in 18 different projects (I withdrew £200 in December to help pay for Christmas). To date I have never lost any money with Kuflink, though some loan terms have been extended once or twice. On the plus side, when this happens additional interest is paid for the period in question.

My loans with Kuflink pay annual interest rates of 6 to 7.5 percent. These days I invest no more than £200 per loan (and often less). That is not because of any issues with Kuflink but more to do with losses of larger amounts on other P2P property platforms in the past. My days of putting four-figure sums into any single property investment are behind me now!

Nowadays I mainly opt to reinvest the monthly repayments I receive from Kuflink, which has the effect of boosting the percentage rate of return on the projects in question

Obviously a possible drawback with Kuflink and similar platforms is that your money is tied up in bricks and mortar, so not as easily accessible as cash savings or even (to some extent) shares. They do, however, have a secondary market on which you can offer any loan part for sale (as long as the loan in question is performing and not in arrears). Clearly that does depend on someone else wanting to buy it, but my experience has been that any loan parts offered are typically snapped up very quickly. So if an urgent need arises, withdrawing your money (or part of it) is unlikely to be an issue.

You can read my full Kuflink review here. They offer a variety of investment options, including a tax-free IFISA paying up to 7% interest per year with built-in automatic diversification. Alternatively you can now build your own IFISA, with most loans on the platform (including the one shown above) being IFISA-eligible.

Last year I set up an account with investment and trading platform eToro, using their popular ‘copy trader’ facility. I chose to invest $500 (then about £412) copying an experienced eToro trader called Aukie2008 (real name Mike Moest). My investment has been up and down in the last few months, but it is currently $33 (about £27) in profit. In these turbulent times I am quite happy with that.

In any event, I’m looking on this as a long-term investment so won’t be judging it yet. I am also considering a further investment with eToro, probably in one of their themed portfolios. You can read my full review of eToro here. You may also like to check out my recent more in-depth look at eToro copy trading.

You might also like to know that eToro recently introduced the eToro Money app. This allows you to deposit money to your eToro account without paying any currency conversion fees, saving you up to £5 for every £1,000 you deposit. You can also use the app to withdraw funds from your eToro account instantly to your bank account. I tried this myself recently and was impressed with how quickly and seamlessly it worked. You can read my more in-depth article about eToro Money here.

I had two more articles published in December on the always-excellent Mouthy Money website. One addressed the question of whether you can Save Money by Cancelling Your TV Licence. I looked at what this entails and what TV you are still permitted to watch without a licence. I also set out some ways you may be able to save money on your TV licence if cancelling altogether is a bridge too far for you.

My other piece was Why We All Need to Be a Bit More Branson! The title is obviously tongue-in-cheek. But the article sets out my strongly held view that – in these challenging times especially – we can all benefit from being a bit more entrepreneurial. I really enjoyed writing this one, I must admit!

Last month I updated my post about the Warm Home Discount, which this year is being increased from £140 to £150. The eligibility rules are changing somewhat, and I shall probably be one of the people who misses out, which is clearly disappointing. But on the plus side, most people won’t now have to apply for this benefit – if you are eligible, the grant should be applied automatically to your bill by your energy company.

The government’s Help for Households website has a helpful summary of all the financial assistance currently available and is regularly updated.

My other posts from December included What Are The Best Video Calling Tools for Older People? and an expert guest post on the subject Why a Passion Investment Could be the Way Forward in Times of Economic Uncertainty. I found the latter quite an eye-opener, as it includes important info about Capital Gains Tax (CGT) I wasn’t previously aware of. The article also sets out some reasons to consider ‘passion investments’ such as fine wines or vintage cars, due to the tax advantages they can confer.

Finally, I published My Top 20 Posts of 2022, which I hope you will check out as well!

That’s all for today. I hope you and your family are coping in these undoubtedly challenging times, and wish you a happy, healthy and prosperous 2023.

As always, if you have any comments or queries, feel free to leave them below. I am always delighted to hear from PAS readers

Disclaimer: I am not a qualified financial adviser and nothing in this blog post should be construed as personal financial advice. Everyone should do their own ‘due diligence’ before investing and seek professional advice if in any doubt how best to proceed. All investing carries a risk of loss.

Note also that posts may include affiliate links. If you click through and perform a qualifying transaction, I may receive a commission for introducing you. This will not affect the product or service you receive or the terms you are offered, but it does help support me in publishing PAS and paying my bills. Thank you!

If you enjoyed this post, please link to it on your own blog or social media:

December 22, 2022

My Top 20 Posts of 2022

Nick Making Money, Saving Money, Investing events, reviews 2 Comments

As is customary for bloggers at this time of year, here are the top twenty posts on Pounds and Sense in 2022, based on comments, page-views and social media shares. They are in no particular order. I have excluded any posts that are no longer relevant.

I hope you will enjoy revisiting these posts, or seeing them for the first time if you are new to PAS.

All posts in the list below should open in a new tab/window when you click on the link concerned.

I’ll be taking a break from blogging over the festive period (though I’ll still be around on Twitter and Facebook). I’ll therefore close by wishing you a Very Merry Christmas (strikes and cost-of-living crisis permitting) and for all of us a much better new year 🍾

If you have any comments or questions, of course, feel free to leave them below as usual.

If you enjoyed this post, please link to it on your own blog or social media:

What You Should Know Before Buying a Holiday Home in Spain

December 13, 2022

What You Should Know About Buying A Holiday Home in Spain

Nick Making Money, Investing guest post, insurance, property, travel 4 Comments

Today I have a guest post for you about something many of us in icebox Britain would no doubt love to do at the moment.

Buying a Spanish holiday home, both for your own enjoyment and as a potential investment, has many attractions. But there are various important matters to consider before signing on that dotted line.

Learn more below 🏖

If you and your partner have spent many happy years holidaying in Spain, perhaps you’d like to consider investing in a Spanish holiday home?

Not only would a stunning sun-kissed property provide a wonderful place to enjoy your retirement years, but you could also let it out while you are not there and make some additional income. After all, Spain is a highly popular vacation spot with much to recommend it, so you would certainly never be short of guests.

Whatever you would like to use your Spanish holiday property for, there are a few important things you need to be aware of before you start house-hunting on the Costa Blanca…

Many Stunning Locations To Choose From

As you surely already know if you relish a vacation in Spain, the country has a plethora of gorgeous locations to choose from. While on the one hand this is clearly a good thing, on the other, it could make deciding on a particular location rather tricky.

If you’re struggling to settle on one spot, take some time to think about your requirements for the property. For example, if you’re planning to purchase a home solely for your own use, it makes sense to choose a property in a location you particularly love. Alternatively, if you’re buying a home as an investment, you may prefer to think about the locale that draws the biggest number of visitors and has the highest rental prices.

Insurance Is Important

Insuring your Spanish holiday home is of the utmost importance, even if you won’t initially be spending a great deal of time there. After all, you never know what might go wrong – from fire and theft to flood damage or structural damage caused by extreme weather. If you don’t have cover then you could be liable for some truly hefty repair bills.

Fortunately, finding the right holiday home insurance for Spain should be a breeze, thanks to Quotezone.co.uk’s helpful comparison service. You can compare and contrast quotes from a range of UK providers and potentially save yourself a lot of time and money along the way.

You Will Need An NIE

When you buy a property in Spain as a foreigner, you will be required by law to have an NIE number. The authorities will be able to use this number to work out how much tax (if any) you owe each year.

Your NIE number can be applied for at the Spanish Consulate in your country of residence or in Spain itself. You will need to fill out forms and provide various supporting documents. The process can take anywhere between two weeks and two months.

Factor In All The Costs

Before you take the plunge and commit to buying your Spanish holiday home, it’s a good idea to dedicate some time to running through all the potential costs you are likely to incur.

After all, you won’t just be paying the asking price of the home itself. You will also have to pay various associated fees, not to mention mortgage payments, lawyers’ fees and surveyor charges.

There will also be additional annual costs, as you will have to keep the property maintained to a good standard, particularly if you’re letting it out.

To ensure a Spanish holiday home is the right choice for you and won’t prove to be too big a drain on your retirement savings, take some time to pause and reflect on the various costs involved. This will help ensure you choose the option that works best for you.

Thank you to my friends at Quotezone.co.uk for an informative article. If you have ever dreamed of owning a holiday property in Spain, I hope it will give you food for thought.

As always, please feel free to leave any comments or questions below as usual. I would be particularly interested to hear from any readers who have gone ahead and bought a property in Spain or are actively considering it.

This is a collaborative post.

If you enjoyed this post, please link to it on your own blog or social media:

December 7, 2022

Guest Post: Why a Passion Investment Could be the Way Forward in Times of Economic Uncertainty

Nick Investing guest post 5 Comments

Today I am pleased to bring you a guest post on a subject I freely admit I didn’t previously know much about.

Of course I was aware of Capital Gains Tax and the annual tax-free allowance. However, it transpires there is much more to know about CGT, especially surrounding the disposal of physical assets known in law as ‘chattels’. But I’ll let my guest Lilly Whale, an expert on this subject, explain in detail…

As well as freezing several tax thresholds, the Chancellor’s Autumn Statement also reduced the annual exemption amount for capital gains tax (CGT) from £12,300 this current tax year to £6,000 in 2023/2024 and to just £3,000 in 2024/2025. Any assets sold above the available threshold may be subject to CGT on the increase in the asset’s value between acquisition and disposal (disposal here means selling and gifting – of particular relevance for parents and grandparents who may wish to make gifts of long-held assets). Typically such assets could include second homes, buy-to-let properties, shares, business assets and valuable personal items such as jewellery and art.

During times of economic uncertainty, people with assets, such as a retirees, may be tempted to invest in alternative assets such as fine wine, art, classic cars and even luxury handbags – after all, the value of the much coveted Hermes Birkin bag has increased annually by approximately 14% over the last 35 years, easily outstripping returns on more traditional assets such as stocks and shares, property and even gold. As well as providing the lucky owners with considerable pleasure, these types of assets (or ‘chattels’) may have tax advantages over traditionally favoured assets, such as stocks and shares. This article focuses on the potential CGT triggers on a chattel’s sale and the potential advantages of investing in an asset of this kind.

What is a chattel?

A chattel is a legal term used to describe an asset which you can both touch and move. Many personal items are categorised as chattels, including books, fine wine, antiques, clothes, shoes, handbags, silverware, records, jewellery, art and cars. The definition also encompasses items of plant and machinery not permanently fixed to a building.

Chattels: exempt from CGT?

Disposals of chattels for £6,000 or less are exempt from CGT. Say, for instance, that you buy a piece of fine art from a little-known artist for £250. Over the next few years, that artist becomes exceptionally popular and you eventually sell the artwork for £5,000 – a realised gain of £4,750. Since the sale proceeds are less than £6,000, the chattels exemption is applicable and no CGT is due.

Sets of items

Care must be taken when a chattel forms part of a set: if the individual parts were owned at the same time and are sold either to the same person, a number of people acting together, or a number of people who are connected (e.g. family members), then the £6,000 limit will apply to the set collectively and not to the individual member of the set.

For example, many years ago you purchased four first-edition books by the same author on the same topic for £5,000 (£1,250 each). Today, the books altogether are worth £20,000 and you sell them all to a book collector.

If the limit was applied to each book’s sale price then all four disposals would be exempt from CGT because individually they are, at £5,000 apiece, under £6,000. However, in HMRC’s eyes the books would be a set and the £6,000 limit cannot apply. There would consequently be a maximum chargeable gain of £15,000 for CGT purposes.

Note that any costs relating to the sale can be deducted from this, and the annual exemption of – at least during the 2022/2023 tax year – up to £12,300, provided it has not been used against other asset sales in the same tax year. Accordingly CGT would be levied on £2,700 at either 18% or 28%.

Other exemptions

Some types of chattels qualify for CGT exemption no matter how large the sale proceeds or gain.

For instance, a private car can be sold for any price without attracting a charge to CGT – including vintage and classic cars. Further specific assets which attract no CGT on disposal are medals or decorations which, HMRC notes, were ‘awarded for valour or gallant conduct’; the seller, however, cannot have ‘acquire[d] it for money or money’s worth’. In practice this means that the seller benefits from this exemption if they were the person who was originally awarded the medal/decoration, or if they are the person to whom the medal/decoration was gifted or left as an inheritance by the individual so-awarded.

Wasting assets

Other chattels which qualify by right for CGT relief are ‘wasting assets’, i.e. assets with a predictable life of 50 years or less. Specific assets within this class range greatly and certain chattels, such as plant or machinery, will always be treated as wasting assets. Highlighted below are a few examples.

While the purchase of fine wine may provide long-term capital growth, whether it is classed as a wasting asset (and the consequent CGT ramifications) is a grey area. An everyday bottle bought from a supermarket (or as HMRC put it, ‘cheap table wine which may turn to vinegar’) would fall squarely within the wasting asset bracket, meaning that CGT on sale is not a consideration; not so, however, for port and other fortified wines with a storage life far beyond 50 years, which would not be considered a wasting asset and CGT on sale may well be relevant. But what about wines which are between these two extremities?

In short, there are several key factors which HMRC would consider when deciding if fine wine is a wasting asset or not and therefore subject to CGT on disposal. It should be noted that the 50-year time limit runs from the wine’s acquisition, not when it was first bottled: thus the drinkability in 50 years’ time of a recently purchased yet very old vintage compared with a relatively young vintage could be starkly different – one may have turned to vinegar; the other simply matured. Investors in this sphere are well-advised to keep detailed records pertaining to the wine’s condition, vintage, provenance, and so on.

Where wine is not considered a wasting asset, the seller can benefit from the £6,000 CGT exemption and therefore disposals of less than this are free from CGT. (Care should be taken if multiple wine bottles are sold at once as the above ‘set’ rules may be triggered.)

Other types of wasting assets include racehorses, shotguns, and clocks and watches (even very expensive ones, as their mechanics are deemed to have a predictable lifespan of not more than 50 years). However, this list is by no means exhaustive and a professional advisor can help to ascertain whether an investment would be considered a wasting asset or not.

There was no indication in the Autumn statement that the various chattels exemptions would be removed; yet clearly CGT thresholds and dispensations are of demonstrable importance to the Government. Now, therefore, seems an opportune moment for individuals to consider what allowances and reliefs – both for CGT and other tax purposes – may be useful and viable, and whether they can realise assets free of tax.

Lilly Whale is an associate in the private client team at RWK Goodman, the law firm.

Many thanks to Lilly Whale (pictured, right) for an informative and eye-opening article. Please do check out her company website (linked above).

As the article indicates, the special tax status of chattels can make them an attractive option for investors, especially if they have maxed out their other tax-free allowances. Passion investments, from rare books to classic cars, antique jewellery to fine art, typically fall into this category.

It is, however, essential to be aware of the rules that apply regarding CGT when the time comes to dispose of the assets in question. The same applies if you currently possess valuable assets you are planning to sell to raise funds (or indeed to give away). In either case, to minimize your tax liability and avoid any potential disputes with HMRC, it may well be advisable to speak to an experienced professional in this field.

As always, if you have any comments or questions about this article, please do leave them below.

Disclaimer: I am not a qualified financial adviser and nothing in this post should be construed as personal financial advice. You should always do your own ‘due diligence’ before investing and take professional advice if in any doubt how best to proceed. All investing carries a risk of loss.

If you enjoyed this post, please link to it on your own blog or social media:

December 5, 2022

My Investments Update – December 2022

Nick Saving Money, Investing events, reviews, benefits 4 Comments

Here is my latest monthly update about my investments. You can read my November 2022 Investments Update here if you like

I’ll begin as usual with my Nutmeg Stocks and Shares ISA. This is the largest investment I hold other than my Bestinvest SIPP (personal pension). I will discuss the latter a bit further down.

As the screenshot below of performance last month shows, my main Nutmeg portfolio is currently valued at £20,391. Last month it stood at £19,733 so that is a rise of £658.

Apart from my main portfolio, I also have a second, smaller pot using Nutmeg’s Smart Alpha option. This is now worth £3,114 compared with £2,987 a month ago, an increase of £127.

Here is a screen capture showing performance since January 2022. As you can see, I topped up this account in February this year.

That is an overall month-on-month increase of £785. Furthermore since mid-October the total value of my Nutmeg investments has risen by £2,007 or around 8%. Anyone who was brave enough to invest in Nutmeg around the middle of October will therefore be looking at a substantial profit now. Of course, it’s always easy to spot an investment opportunity with 20/20 hindsight!

In my case, while the recent rises are very welcome, my Nutmeg investments are still down £1,607 or about 6.5% since the start of the year. To put this in context, though, in 2021 they rose by £3,552 (over 21%). And overall, I am still over £6,000 ahead since I started investing with Nutmeg in 2016. For my main portfolio that represents a return on capital of 42% or 51.03% time-weighted.

Of course, the real point of this is that investing is (or should be) a long-term endeavour. Over a period of years stock market investments such as those used by Nutmeg typically produce better returns than cash accounts, often by substantial margins. But there are never any guarantees, and in in the short to medium term at least, losses are always possible.

You can read my full Nutmeg review here (including a special offer at the end for PAS readers). If you are looking for a home for your annual ISA allowance, based on my experience over the last six years, they are certainly worth considering.

Moving on, my Assetz Exchange investments continue to perform well. Regular readers will know that this is a P2P property investment platform focusing on lower-risk properties (e.g. sheltered housing). I put an initial £100 into this in mid-February 2021 and another £400 in April. In June 2021 I added another £500, bringing my total investment up to £1,000.

Since I opened my account, my AE portfolio has generated £88.30 in revenue from rental and £17.59 in capital growth, a total of £105.89. That’s a decent rate of return on my £1,000 investment and does illustrate the value of P2P property investment for diversifying your portfolio when equity markets are volatile.

I now have investments in 23 different projects and all are performing as expected, generating rental income and in most cases showing a profit on capital as well. So I am very happy with how this investment has been doing. And it doesn’t hurt that most projects are socially beneficial as well.

To control risk with all my property crowdfunding investments nowadays, I invest relatively modest amounts in individual projects. This is a particular attraction of AE as far as i am concerned. You can actually invest from as little as 80p per property if you really want to proceed cautiously.

My investment on Assetz Exchange is in the form of an IFISA so there won’t be any tax to pay on profits, dividends or capital gains. I’ve been impressed by my experiences with Assetz Exchange and the returns generated so far, and intend to continue investing with them. You can read my full review of Assetz Exchange here. You can also sign up for an account on Assetz Exchange directly via this link [affiliate].

Another property platform I have investments with is Kuflink. They continue to do well, with new projects launching almost every day. I currently have around £2,600 invested with them in 14 different projects. To date I have never lost any money with Kuflink, though some loan terms have been extended once or twice. On the plus side, when this happens additional interest is paid for the period in question. At present most of my Kuflink loans are performing to schedule, though two recently had their repayment dates put back by three months.

My loans with Kuflink pay annual interest rates of 6 to 7.5 percent. These days I invest no more than £200 per loan (and often less). That is not because of any issues with Kuflink but more to do with losses of larger amounts on other P2P property platforms in the past. My days of putting four-figure sums into any single property investment are behind me now!

Nowadays I mainly opt to reinvest the monthly repayments I receive from Kuflink, which has the effect of boosting the percentage rate of return on the projects in question

Obviously a possible drawback with Kuflink and similar platforms is that your money is tied up in bricks and mortar, so not as easily accessible as cash savings or even (to some extent) shares. They do, however, have a secondary market on which you can offer any loan part for sale (as long as the loan in question is performing and not in arrears). Clearly that does depend on someone else wanting to buy it, but my experience has been that any loan parts offered are typically snapped up very quickly. So if an urgent need arises, withdrawing your money (or part of it) is unlikely to be an issue.

You can read my full Kuflink review here. They offer a variety of investment options, including a tax-free IFISA paying up to 7% interest per year with built-in automatic diversification. Alternatively you can now build your own IFISA, with most loans on the platform (including the one shown above) being IFISA-eligible.

My investment in European crowdlending platform Nibble continues to perform as advertised. My latest investment was in their Legal Strategy. These are loans that are in default and facing legal action. Nibble buy these loans at a heavily discounted rate and then seek to recover as much as possible of the money owed. The minimum investment is 10 euros and the minimum period is six months. I invested 100 euros for 12 months initially at a target annual interest rate of 12.5%.

The Legal Strategy comes with a deposit-back guarantee. This is a guarantee to return the full investment amount at the end of the investment period and a minimum yield of 9% per year. The actual yield depends on how successful recovery efforts prove, so in practice you may end up with a return of anywhere between 9% and 14.5%. All has gone to plan so far, but I will obviously continue to report on this in the months ahead.

You can read my updated review of Nibble here if you like. You can also sign up directly on the Nibble website [affiliate link].

Earlier this year I set up an account with investment and trading platform eToro, using their popular ‘copy trader’ facility. I chose to invest $500 (then about £412) copying an experienced eToro trader called Aukie2008 (real name Mike Moest). My investment has been up and down in the last few months, but it is currently $38 (about £31) in profit. In these turbulent times I am quite happy with that.

In any event, I’m looking on this as a long-term investment so won’t be judging it yet. I am also considering a further investment with eToro, possibly in one of their themed portfolios. You can read my full review of eToro here. You may also like to check out my recent more in-depth look at eToro copy trading.

Moving on, earlier I mentioned my Bestinvest SIPP (personal pension). This is now in drawdown, but regular readers will know that I suspended withdrawals from it in May this year to reduce the risk of pound-cost ravaging. I was able to do this because since December 2021 I have been receiving the state pension. And in association with my other income streams this has given me enough to live on (though by no means in luxury).

Anyway, with the cost of living crisis starting to bite, and energy bills shooting up at an alarming rate, I decided the time had come to resume taking payments from my SIPP. Plus, with the markets seemingly on an upward trajectory, the risk of pound-cost ravaging appeared to have receded.

I therefore asked Bestinvest to reinstate my payments from this month, though at a lower rate of £100 a month. One of the attractions of flexible drawdown pensions such as those from Bestinvest is that you can increase or decrease withdrawals at any time or even (as I did) suspend them completely. Obviously if you draw an excessive amount there is a risk of depleting your fund too quickly, so it runs out before you do. But Bestinvest sent me some reassuring projections that in any feasible scenario this was unlikely to happen in my case even if I live to the age of 99 (as I fully intend to 😀 ).

One other consideration I had with my SIPP is that withdrawals from it are taxable, whereas withdrawals from some of my other investments (e.g. Nutmeg ISA) are not. With the state pension also being taxable, this means withdrawing larger amounts from my SIPP would result in a portion of the money being grabbed by the taxman, which seems a waste. While I do of course accept that taxes have to be paid, I prefer to minimize my liability as much as possible (which we are all perfectly entitled to do).

You can read my full review of Bestinvest here if you like.

I had two more articles published in November on the always-excellent Mouthy Money website. One of them was Win Fame and (Maybe) Fortune as a Quiz Show Contestant. This is something I have done myself in the past and enjoyed writing about again for MM. It can be a lot of fun, and any prizes you win are tax-free under UK law.

My other article was How to Cash in on Your Old Tech. Most of us have old technology we no longer use gathering dust in cupboards and drawers. This articles sets out ways you can make some much-needed cash out of this.

Obviously energy bills are a particular concern for many people at the moment, so I hope you are getting all the help you are entitled to. Everyone should be receiving a monthly rebate of £66 on their energy bill (going up to £67 in the new year). If you’re not, chase it up with your energy supplier.

I also recently updated my post about the Warm Home Discount, which this year is being increased from £140 to £150. The eligibility rules are changing somewhat, and I shall probably be one of the people who misses out, which is clearly disappointing. But on the plus side, most people won’t now have to apply for this benefit – if you are eligible, it should be applied automatically to your bill by your energy company.

The government’s Help for Households website has a helpful summary of all the financial assistance currently available and is regularly updated.

Please do check out as well some of the other posts on Pounds and Sense for advice and resources, especially in the Making Money and Saving Money categories.

Don’t forget, also, that there are currently two opportunities to claim a free share available. One is with Wealthyhood and the other with Trading 212 (the links will take you to the relevant blog posts). The current Trading 212 offer closes on 29 December 2022, so don’t delay if you want to take advantage of this one. As far as I know the Wealthyhood offer is open indefinitely, but that could always change, of course

That’s all for today. I hope you and your family are coping in these challenging times and wish you the happiest Christmas possible. I shall of course continue to update this blog over the coming weeks, and will return with a further update about my investments at the start of January.

As always, if you have any comments or queries, feel free to leave them below. I am always delighted to hear from PAS readers

Disclaimer: I am not a qualified financial adviser and nothing in this blog post should be construed as personal financial advice. Everyone should do their own ‘due diligence’ before investing and seek professional advice if in any doubt how best to proceed. All investing carries a risk of loss.

Note also that posts may include affiliate links. If you click through and perform a qualifying transaction, I may receive a commission for introducing you. This will not affect the product or service you receive or the terms you are offered, but it does help support me in publishing PAS and paying my bills. Thank you!

If you enjoyed this post, please link to it on your own blog or social media:

November 22, 2022

Guest Post: How To Get Started as a Home-Based Crypto Investor

Nick Investing guest post 4 Comments

Today I have a guest post for you on a subject I don’t generally cover on Pounds and Sense.

Cryptocurrency investing/trading is risky and I appreciate that it may not appeal to many readers of this blog. On the other hand, I can’t deny there is a lot of interest in crypto, from younger people in particular. So today I am publishing a guest post for anyone who might be interested in finding out a bit more…

While some people prefer to invest in crypto as a side hustle, others want to take it a step further and become a full-time home-based crypto investor.

Investing time and money into crypto can be risky, so it’s important that you know what you are doing and you pay attention to how the markets change. In this article we will go over a few tips and tricks to help you get started.

Create a Working Space

One of the first things you will need to do is set up a working space for yourself. It is important that you have a designated area to work in, as this will help you stay concentrated and focused throughout the day. If you can, it would be a good idea to have your workspace away from anything else, as this will stop you from getting distracted. A spare room or even just a corner in one room of your house will work well.

Keep Updated with Crypto News

Keeping up to date with crypto news is a great way to start off as a crypto investor. The financial markets can be volatile, so you must stay current with all the latest changes so that you can make any necessary adjustments to your investments. There are plenty of ways to stay up to date, but it could be helpful to download a crypto app that will help you manage your investments and also learn about any changes to the market.

Research Ways to Earn Bitcoin

It would be beneficial for you as a home-based crypto investor to start researching ways that you can earn Bitcoin, one of the most popular types of cryptocurrency. Learning the different ways you can earn Bitcoin will help you become a successful investor. One way you can earn Bitcoin is by trading a gift card you don’t need for it. Paxful allows you to safely buy Bitcoin with a gift card, which makes earning Bitcoin super easy.

Join Crypto Communities

If you are new to the world of cryptocurrency, then a good way to get started is joining different crypto communities. There are plenty of discord servers or Reddit subs that are specifically for crypto investors, so these can be helpful to be a part of. Users share their different experiences with the crypto market and offer advice and suggestions about when and how you should invest. For someone starting out as a crypto investor this can be invaluable, as you will learn about crypto from people who have more knowledge and experience than you (though don’t take everything you read as gospel!). Having a supportive community behind you will allow you to learn and grow as a crypto investor.

Thank you to my friends at Paxful for an interesting article.

Just to emphasize what I said at the start, cryptocurrency trading is high risk and definitely not for everyone. Yes, you can make a lot of money, but you can also lose your shirt!

My personal advice if nonetheless you want to explore cryptocurrency trading/investment is to start small with money you can afford to lose in a worst-case scenario. I also like the idea mentioned in the article of earning cryptocurrency rather than buying it. Obviously if your crypto is something you have earned or otherwise acquired yourself (perhaps by exchanging a gift card), losing it isn’t likely to be as painful 😮

I would love to hear your reactions to this article, and whether you think I should cover cryptocurrency more often on Pounds and Sense. I’d also be interested to hear about your personal experiences with crypto (no spam, please). Please leave any comments or questions below as usual.

This is a collaborative post.

Disclaimer: Nothing in this article should be construed as personal financial advice. As stated in the article, cryptocurrency trading/investment can be very high risk and is not suitable for everyone. Proceed with care and take professional advice if in any doubt whether it is right for you. All investing carries a risk of loss and this is especially so with cryptocurrencies.

If you enjoyed this post, please link to it on your own blog or social media:

November 14, 2022

Ten Reasons Over-50s May Need an Independent Financial Adviser

Nick Pensions & Benefits, Saving Money, Investing property, sponsored post, pensions, benefits 6 Comments

I’ve mentioned several times on PAS why I believe having an independent financial adviser makes sense, even if – like me – you consider yourself reasonably money-savvy.

So today I thought I would set out some reasons over-50s (in particular) may benefit from having an independent financial adviser (IFA) or at least speaking to one.

This post has been created in association with my colleagues at Unbiased.co.uk, a well-established financial services website that can put you in touch with suitable IFAs in your area.

Reasons for Having an IFA

1. Helping Your Children Through College or University

If you have children, you will naturally want to help them complete their education safely and with a reasonable degree of comfort. Sadly the days of student grants (which I was lucky enough to benefit from in the 1970s) are well behind us now. There are various options for helping finance your children’s college or university education and a financial adviser will be able to explore these with you. They will also explain the pros and cons of the student loans system.

2 – Pension Planning

If you are over 50 you will inevitably be thinking about pension options, including when you can retire and how much income you can expect. An IFA will go through your finances with you and look at ways you may be able to boost your pension pot. From 55 onwards you can normally start to draw your pension, but you shouldn’t do this unless a financial adviser has assured you it will last you through retirement.

3. Investing

Hopefully by your fifties you will be earning a decent salary and may also have paid off your mortgage. You may also receive an inheritance or other windfall. Either way, if you find yourself with some spare cash you will want to invest it to get the best possible returns from it. An IFA will have access to all the latest information about a vast range of investment opportunities. They will guide you towards investments that are suitable for you based on your financial goals, your investment timeframe and your appetite for risk.

4. Starting Your Own Business

Especially at this time of upheaval due to Covid, many people are looking to start their own businesses in mid-life. That may be in response to redundancy or unemployment, or simply in search of a better work/life balance. An IFA can help you with the financial aspects of doing this, including raising money for tools, premises, transport and so on, or perhaps buying a franchise.

5. Emigrating or Retiring Abroad

Another way to revitalize your life may be to start afresh somewhere else, with new challenges and opportunities (and perhaps a better climate as well!). Or you may be looking to move to a favourite vacation destination to enjoy your retirement. Either way, an IFA will be happy to discuss the pros and cons with you, point out all the things you will need to take into account, and assist you with the financial arrangements.

6. Divorce

Sadly middle age sees the largest number of divorces. Your first priority here will be appointing a good solicitor to act on your behalf and protect your interests. Beyond that, though, divorce can have major ramifications for your finances. An IFA can help you assess your situation objectively and plan for a financially secure and stable future.

7. Downsizing

As the children grow up and leave home you may want to move to a smaller property – to make life simpler, save time on housework and free up money for more exciting things. An IFA can help you explore the implications of doing this and make the necessary financial arrangements.

8. Equity Release

If you don’t want to move – and are over 55 – equity release is another option for releasing funds. In recent years it has grown a lot in popularity. There are various possibilities, including home reversion plans and flexible lifetime mortgages. Most now come with a no-negative-equity guarantee, ensuring you won’t end up passing on debts to your next of kin. An IFA can go over the options with you and point out the pros and cons before you contact any providers.

9. Estate Planning

This obviously includes writing your will, but depending on your circumstances it can cover a lot of other things as well. Nobody wants to see all their money and assets falling into the hands of the taxman rather than going to their nearest and dearest. Speaking to an IFA who specializes in estate planning can give peace of mind and ensure that your loved ones are well provided for when you are no longer here yourself.

10. Helping Elderly Relatives

If you have elderly parents (or other relatives) you may find they are increasingly reliant on you for help and support. It may be up to you to arrange care for them and/or set up power of attorney so you can manage their affairs if this becomes necessary. They may also need help with estate planning (see above). An IFA can assist with all these things as well.

Getting a Free Financial Check-Up

Independent financial advisers do of course charge for their services. They are by definition unaffiliated and do not receive commission, so any recommendations they make are based solely on their client’s best interests. As I have said before on PAS, I certainly don’t begrudge paying my own financial adviser, Mike, as he has undoubtedly saved (and made) me a lot more money than he has cost me over the years.

Nonetheless, most IFAs will be happy to see you for an initial financial healthcheck free of charge. This can focus on a particular area of concern, so you could request an investments review, a pension review or a mortgage review. Alternatively, if you’re not sure which aspect of your finances needs more attention – or indeed whether you need advice at all – you could simply request a broad financial healthcheck.

Here’s what. Adrian Kidd, a financial planner at Radcliffe & Newlands, says about his approach on the Unbiased website:

‘I’d generally offer one or possibly two free consultations, taking about an hour, and these can be as specific or as broad as required. When someone books a financial healthcheck with me, I ask them to bring along all their documents relating to their finances – savings, investments, mortgages, loans, insurance, pensions, the works – so I can build up a complete picture of their affairs. I then go through these in more detail after the consultation, and follow up with an email that gives a summary of their overall financial situation.’

In these free check-ups: advisers won’t generally talk to you about products at all. The process of choosing the right products comes later, after the adviser has built up an understanding of you as a person and your financial planning needs. Only then will they recommend products, if asked to do so.

If you follow my link to the Unbiased website, you can complete a short, step-by-step questionnaire designed to identify the best type of financial adviser for your needs. You will then be shown a selection of suitable advisers in your area with contact information. They will be happy to answer any queries you may have and arrange an initial meeting without obligation.

As ever, if you have any comments or questions about this post, please do leave them below.

Disclosure: This is a sponsored post on behalf of Unbiased.co.uk. If you click through my link and end up becoming a client of a financial adviser listed on the Unbiased site, I may receive a commission for introducing you. This will not affect the service you receive or any fees you are charged if you decide to proceed further.

This is a fully updated version of a post originally published in 2020.

If you enjoyed this post, please link to it on your own blog or social media:

November 1, 2022

My Investments Update – November 2022

Nick Investing events, reviews 4 Comments

Here is my latest monthly update about my investments. You can read my October 2022 Investments Update here if you like

I’ll begin as usual with my Nutmeg Stocks and Shares ISA. As I only updated my full review of Nutmeg last week, however, I will keep it fairly brief today.

Nutmeg is the largest investment I hold other than my Bestinvest SIPP (personal pension). Withdrawals from the latter are still on hold to avert the risk of pound-cost ravaging.

My main Nutmeg portfolio, which I opened back in 2016, is currently valued at £19,733. Last month it stood at £19,292 so that is a rise of £441. My smaller Smart Alpha investment (opened in 2020) is currently valued at £2,987. Last month it stood at £2,921, so that is a rise of £66. My total Nutmeg investments have therefore increased by £507 month on month.

While the rise in October is of course welcome, my Nutmeg investments are still down by about 11% in value since the start of the year. As I said in my recent Nutmeg review, that’s clearly disappointing, but it’s still a lot less than the amount by which they went up in 2021 alone. And I am still over £5,400 in profit overall. I am therefore philosophical about this, recognising that all investments have their ups and downs and Nutmeg is hardly alone in seeing a drop in values this year. But I do understand why people who started investing with them in the last twelve months or so may be feeling disappointed. You might like to read this recent article on the Nutmeg blog where they discuss the performance of Nutmeg portfolios in 2022 and examine the outlook going forward.

There is actually an argument that now may be a good opportunity to invest while asset values are depressed. At some point we will see a recovery and people who invest at the present time will be well placed to benefit from this. Of course, nobody knows for sure when the recovery will happen or how much further asset values might fall first. Nonetheless, I am certainly considering adding further to my Nutmeg investments in the coming months.

Moving on, my Assetz Exchange investments continue to perform well. Regular readers will know that this is a P2P property investment platform focusing on lower-risk properties (e.g. sheltered housing). I put an initial £100 into this in mid-February 2021 and another £400 in April. In June 2021 I added another £500, bringing my total investment up to £1,000.

Since I opened my account, my AE portfolio has generated £81.40 in revenue from rental and £30.80 in capital growth, a total of £112.20. That’s a decent rate of return on my £1,000 investment and does illustrate the value of P2P property investment for diversifying your portfolio when equity markets are volatile.

I now have investments in 23 different projects and all are performing as expected, generating rental income and in most cases showing a profit on capital as well. So I am very happy with how this investment has been doing. And it doesn’t hurt that most projects are socially beneficial as well.

To control risk with all my property crowdfunding investments nowadays, I invest relatively modest amounts in individual projects. This is a particular attraction of AE as far as i am concerned. You can actually invest from as little as 80p per property if you really want to proceed cautiously.

My investment on Assetz Exchange is in the form of an IFISA so there won’t be any tax to pay on profits, dividends or capital gains. I’ve been impressed by my experiences with Assetz Exchange and the returns generated so far, and intend to continue investing with them. You can read my full review of Assetz Exchange here. You can also sign up for an account on Assetz Exchange directly via this link [affiliate].

Another property platform I have investments with is Kuflink. They continue to do well, with new projects launching almost every day. I currently have around £2,600 invested with them in 17 different projects. To date I have never lost any money with Kuflink, though some loan terms have been extended once or twice. On the plus side, when this happens additional interest is paid for the period in question. At present most of my Kuflink loans are performing to schedule, though five have had their repayment dates put back.

My loans with Kuflink pay annual interest rates of 6 to 7.5 percent. These days I invest no more than £200 per loan (and often less). That is not because of any issues with Kuflink but more to do with losses of larger amounts on other P2P property platforms in the past. My days of putting four-figure sums into any single property investment are behind me now!

Nowadays I mainly opt to reinvest the monthly repayments I receive from Kuflink, which has the effect of boosting the percentage rate of return on the projects in question

Obviously a possible drawback with Kuflink and similar platforms is that your money is tied up in bricks and mortar, so not as easily accessible as cash savings or even (to some extent) shares. They do, however, have a secondary market on which you can offer any loan part for sale (as long as the loan in question is performing and not in arrears). Clearly that does depend on someone else wanting to buy it, but my experience has been that any loan parts offered are typically snapped up very quickly. So if an urgent need arises, withdrawing your money (or part of it) is unlikely to be an issue.

You can read my full Kuflink review here. They offer a variety of investment options, including a tax-free IFISA paying up to 7% interest per year with built-in automatic diversification. Alternatively you can now build your own IFISA, with most loans on the platform (including the one shown above) being IFISA-eligible.

My investment in European crowdlending platform Nibble continues to perform as advertised. My latest investment was in their Legal Strategy. These are loans that are in default and facing legal action. Nibble buy these loans at a heavily discounted rate and then seek to recover as much as possible of the money owed. The minimum investment is 10 euros and the minimum period is six months. I invested 100 euros for 12 months initially at a target annual interest rate of 12.5%.

The Legal Strategy comes with a deposit-back guarantee. This is a guarantee to return the full investment amount at the end of the investment period and a minimum yield of 9% per year. The actual yield depends on how successful recovery efforts prove, so in practice you may end up with a return of anywhere between 9% and 14.5%. All has gone to plan so far, but I will obviously continue to report on this in the months ahead.

You can read my updated review of Nibble here if you like. You can also sign up directly on the Nibble website [affiliate link]

Earlier this year I set up an account with investment and trading platform eToro, using their popular ‘copy trader’ facility. I chose to invest $500 (then about £412) copying an experienced eToro trader called Aukie. Unsurprisingly my investment has been up and down in the last few months, but it is currently about $8 in profit. In these turbulent times I am quite happy with that.

In addition, since I started on eToro, the pound has weakened against the US dollar, so my investment has benefited from this. My $508 US is now worth around £440 in UK pounds, so I am effectively £28 up overall. I am not claiming this as a particular benefit of eToro, but it does demonstrate how exchange rate fluctuations can sometimes work in your favour!

In any event, I’m looking on this as a long-term investment so won’t be judging it yet. I am also considering a further investment with eToro, possibly in one of their themed portfolios. You can read my full in-depth review of eToro here. I am also planning to publish a more in-depth look at eToro copy trading on the blog soon.

Moving on, I had another article published on the always-excellent Mouthy Money website. This one is entitled How to Save Money on Petrol. I was actually commissioned to write this when petrol prices were peaking. Since then they have fallen back somewhat, but with no end in sight to the war in Ukraine prices could easily shoot back up again. In the article I discuss my favourite website for monitoring petrol prices locally and also set out my top tips for cutting your petrol (or diesel) consumption.

As a matter of interest, Mouthy Money recently asked if I could increase the number of articles I write for them (so I guess I must be doing something right!). From November they will be publishing two articles a month from me. While they don’t pay me a fortune, the extra cash will undoubtedly help a lot in the cold winter months ahead.

Obviously energy bills are a particular concern for many people at the moment, so I hope you are getting all the help you are entitled to. By now everyone should have received the first instalment (£66) of the £400 rebate all UK residents are due on their energy bills for the next six months. If not, chase it up with your energy supplier.

I am with EDF, and they are crediting the rebate payments to my bank account once my monthly direct debit has been taken. Other energy suppliers are doing it differently, e.g. deducting the rebate from monthly direct debits before they are taken. This article from the popular Moneysavingexpert website explains how different energy suppliers are applying the rebate.

I also received a letter last week confirming that, as I receive the state pension, I shall be getting an enhanced Winter Fuel Payment of £500 in November or December this year, which will be very welcome as well 🙏

In the last few years I also qualified for the Warm Home Discount, which this year is being increased from £140 to £150. The rules are changing, however, and I suspect I shall be one of the people who misses out. The full new rules still haven’t been announced, but I will update my blog post about WHD as soon as I know more.

As I’ve said previously, the government’s Help for Households website has a helpful summary of all the financial assistance currently available and is regularly updated.

Please do check out as well some of the other posts on Pounds and Sense for advice and resources, especially in the Making Money and Saving Money categories.

Don’t forget, also, that there are currently two opportunities to claim a free share available. One is with Wealthyhood and the other with Trading 212 (the links will take you to the relevant blog posts). The Trading 212 offer closes on 8 November 2022, so don’t delay if you want to take advantage of this one. As far as I know the Wealthyhood offer is open indefinitely, but that could always change, of course 🙂

That’s all for today. As always, if you have any comments or queries, feel free to leave them below. I am always delighted to hear from PAS readers

Disclaimer: I am not a qualified financial adviser and nothing in this blog post should be construed as personal financial advice. Everyone should do their own ‘due diligence’ before investing and seek professional advice if in any doubt how best to proceed. All investing carries a risk of loss.

Note also that posts may include affiliate links. If you click through and perform a qualifying transaction, I may receive a commission for introducing you. This will not affect the product or service you receive or the terms you are offered, but it does help support me in publishing PAS and paying my bills. Thank you!

If you enjoyed this post, please link to it on your own blog or social media:

How to Track Your Investments With Microsoft Excel

October 28, 2022

How to Track Investments With Microsoft Excel

Nick Investing, Everything Else guest post 4 Comments

Investing can be confusing, and it’s easy to lose track of where your money is going. Thankfully, Microsoft Excel has many tools that can help you effortlessly track your investments.

Excel offers many ways for users to easily track their investments, such as by tracking the value of their portfolio over time, analyzing past performance, and comparing how different asset classes performed in similar market conditions.

Excel can also help investors stay on top of balances and transaction activity across multiple accounts. It allows them to visualize how these transactions affect their total wealth over time. This information can help investors decide when to invest more or pull out some cash for other uses.

Excel can be beneficial for investment tracking, especially if you’re saving for retirement and want to see how much progress you’ve made over time.

You can either enrol in Excel training to learn a few tips or tricks to analyze your investment data (which will serve you well for life), or you can follow the guide below for a quick solution.

Create a Portfolio

A portfolio is a collection of individual investments held by an investor. A typical portfolio will include stocks, bonds, mutual funds, exchange-traded funds (ETFs), options, and other securities.

If you’re looking to create a portfolio in Excel, here’s how to do it:

1. Open up the spreadsheet application on your computer,

2. Click on ‘File’ and select ‘New’.

3. Select ‘Blank Workbook’ from the new screen’s drop-down menu. This will open up a new file for you to start creating your portfolio in Excel.

4. Type the heading ‘Accounts’ in one of the columns. The accounts should be listed from largest to smallest by value or assets under management (AUM). We recommend listing these accounts as rows instead of columns to make it easy to track.

5. Create columns for the type of investment you have in your portfolio against each account. These include cash accounts, bonds, fixed-income funds, stocks and equity funds, commodities, and other assets like real estate or intellectual property rights.

6. Now create another column with the heading ‘Shares/Investment’ and enter the data for each investment appropriately.

7. You can add columns related to Date, Security Name, Number of Shares or Units Owned, Purchase Price Per Share/Unit (or Cost Basis), and Current Market Value Per Share/Unit (or Current Value). In addition, add columns for Cost Basis (the original purchase price), Gain/Loss Per Unit, and Total Gain/Loss For All Units (for each security).

8. You may also want to include columns for Percent Gain/Loss.

9. Save the spreadsheet as an Excel file and then close it.

Use the ‘Difference Formulas’ in Excel

Excel’s most useful feature is its ability to calculate differences between two numbers. For example, if you have a list of investment values and you want to know how much money you have made since your purchase, you can try the following method:

1. Click the cell where you want to calculate the difference between your asset’s current price minus its original purchase value.

2. Type the equal sign ‘=’ and then select the cell containing the current value of your investment.

3. Type the minus sign ‘-‘ and then select the cell containing the original purchase price of the investment.

4. Press enter, and the difference will be calculated.

5. Now click and press the small square at the end of that cell (containing the difference), and drag it downwards to calculate the difference of each dataset automatically.

Use the ‘Percent Return Formulas’ in Excel

To track the return on investment over time, you can use Microsoft Excel’s percent return formulas. These formulas calculate the percentage increase or decrease in an investment’s value over time.

The formula for percent return is: (Current price – Purchase price) ÷ Purchase price

Here’s how you can apply the percent return formula in Excel:

1. Select the cell where you want the percent return formula to be calculated.

2. Type the equal sign ‘=’ and add an open parenthesis ‘(‘.

3. Select the cell containing the current value of your investment.

4. Type the minus sign ‘-‘ and select the cell containing the original purchase price of your investment and then close the parenthesis ‘)’.

5. Now, type the forward slash ‘/’ and select the cell containing the original purchase price.

6. Press enter, and the percent return will be calculated.

7. To make values appear as percentages, right-click on the cell, select the option of Format Cells, and select Percentage under the number tab.

8. Once done, click and drag the small square at the bottom right corner of your percent return cell and copy the formula for the rest of the dataset.

Use Advanced Excel Features to Customize your Sheet

Functions in Excel are a way for you to manipulate data in Excel programmatically. They can be used to perform calculations, transform data, and create new values.

You can find a list of all built-in functions in the Formula tab menu in Excel. To access it, click on any cell, navigate to the Formula tab and choose the ‘Insert Function’ option. The Insert Function dialogue box will appear, from where you can choose the function you are looking for by going through the list.

Here are the 10 most popular functions in Excel:

SUM function
IF function
LOOKUP function
VLOOKUP function
MATCH function
CHOOSE function
DATE function
DAYS function
INDEX function
FIND, FINDB functions

The best way to learn about each function is by using it. Try out different arguments and see what happens.

To Conclude

Excel is an excellent way to track investments because it saves and calculates dependable data. Also, you can use the program to graph your data and see how they change over time.

Thank you to my friends at Acuity Training for an informative guest article.

I use Excel spreadsheets for keeping track of my self-employed earnings and send them to my accountant once a year so that he can produce my annual accounts from them.

I do also use Excel for keeping track of my investments, but only in a very basic way. This article has inspired me to be a bit more ambitious with Excel and use formulas to automatically calculate the total and percentage returns from my investments, and so forth.

As always, if you have any comments or questions about this post, please do leave them below.

If you enjoyed this post, please link to it on your own blog or social media:

October 3, 2022

My Investments Update – October 2022

Nick Investing, Everything Else reviews, travel, events 4 Comments

Here is my latest monthly update about my investments. You can read my September 2022 Investments Update here if you like

I’ll begin as usual with my Nutmeg Stocks and Shares ISA. This is the largest investment I hold other than my Bestinvest SIPP (personal pension). Withdrawals from the latter are still on hold, incidentally, to avert the risk of pound-cost ravaging.

As the screenshot below of performance last month shows, my main portfolio is currently valued at £19,292. Last month it stood at £20,344 so that is a fall of £1,052.

Apart from my main portfolio, I also have a second, smaller pot using Nutmeg’s Smart Alpha option. This is now worth £2,921 compared with £3,091 a month ago, another fall of £170.

Here is a screen capture showing performance since January 2022. As you can see, I topped up this account in February this year.

There is no denying that these falls are disappointing, especially with my Smart Alpha portfolio now worth less in total than I have contributed to it. As I’ve noted previously on PAS, however, you do have to expect ups and downs with equity-based investments. And this year there has been no lack of volatility, caused by rising inflation, the war in Ukraine and the aftermath of the pandemic (among other things).

About my only consolation is that things could have been even worse if – paradoxically – I’d opted for a lower-risk level with my investments. In their latest blog update, Nutmeg reveal that low and medium-risk portfolios actually performed worse overall last month than high-risk ones. I have copied below their explanation for this:

By design, Nutmeg’s low- and medium-risk portfolios have more exposure through ETFs to assets that are priced in sterling and with limited foreign currency exposure. As you will have seen in the headlines this week, the pound hit an all-time low against the dollar with markets initially placing little faith in the chancellor’s tax-cutting and pro-growth agenda.

This year it has been rewarding to hold foreign currency with sterling particularly weak versus the dollar. Some of our high-risk portfolios have benefited from currency moves, while low- and medium-risk portfolios have not. They haven’t lost money from having low foreign currency exposure, they just haven’t benefited from it.

Secondly, low- and medium-risk portfolios by design have more exposure – again through ETFs – to government bonds, which in ‘normal’ times are considered something of a safe haven and have much lower volatility than equities. After all, it is still highly unlikely that the UK government would default on its debts.

In a nutshell (no pun intended) low- and medium-risk Nutmeg portfolios hold a higher proportion of investments in pounds sterling and UK government bonds. These are normally regarded as lower risk, but last month both took a particular hammering. So in comparison nominally higher-risk portfolios like mine actually performed somewhat better.

This is one more reason I’m glad I opted for higher risk levels with my Nutmeg portfolios (9/10 for my main one and 5/5 for my Smart Alpha). If you haven’t yet seen it, you might also like to check out my blog post in which I looked at the performance over time of Nutmeg fully managed portfolios at every risk level from 1 to 10 . I was actually pretty amazed by the difference risk level makes, with higher-risk ports over almost any period of three or more years in the last ten generating significantly better overall returns. If you are investing for the long term (and you almost certainly should) opting for a hyper-cautious low-risk strategy may not be the smartest thing to do.

Since I started investing with Nutmeg in 2016 – and despite everything that has happened this year – I have still made a total net return on capital of £4,977 (35% or 52.35% time-weighted) on my main portfolio. So I can afford to be philosophical about the recent falls. Indeed, I am considering topping up my Nutmeg investments again now while asset values are depressed.

You can read my full Nutmeg review here (including a special offer at the end for PAS readers). If you are looking for a home for your annual ISA allowance, based on my experience over the last six years, they are certainly worth considering.

Moving on, my Assetz Exchange investments continue to perform well. Regular readers will know that this is a P2P property investment platform focusing on lower-risk properties (e.g. sheltered housing). I put an initial £100 into this in mid-February 2021 and another £400 in April. In June 2021 I added another £500, bringing my total investment up to £1,000.

Since I opened my account, my AE portfolio has generated £76.51 in revenue from rental and £63.58 in capital growth, a total of £140.09. That’s a decent rate of return on my £1,000 investment and does illustrate the value of P2P property investment for diversifying your portfolio when equity markets are volatile.

I now have investments in 23 different projects and all are performing as expected, generating rental income and in most cases showing a profit on capital as well. So I am very happy with how this investment has been doing. And it doesn’t hurt that most projects are socially beneficial as well.

To control risk with all my property crowdfunding investments nowadays, I invest relatively modest amounts in individual projects. This is a particular attraction of AE as far as i am concerned. You can actually invest from as little as 80p per property if you really want to proceed cautiously.

My investment on Assetz Exchange is in the form of an IFISA so there won’t be any tax to pay on profits, dividends or capital gains. I’ve been impressed by my experiences with Assetz Exchange and the returns generated so far, and intend to continue investing with them. You can read my full review of Assetz Exchange here. You can also sign up for an account on Assetz Exchange directly via this link [affiliate].

Another property platform I have investments with is Kuflink. They continue to do well, with new projects launching almost every day. I currently have around £2,500 invested with them in 14 different projects. To date I have never lost any money with Kuflink, though some loan terms have been extended once or twice. On the plus side, when this happens additional interest is paid for the period in question. At present most of my Kuflink loans are performing to schedule, though two recently had their repayment dates put back by three months.

My loans with Kuflink pay annual interest rates of 6 to 7.5 percent. These days I invest no more than £200 per loan (and often less). That is not because of any issues with Kuflink but more to do with losses of larger amounts on other P2P property platforms in the past. My days of putting four-figure sums into any single property investment are behind me now!

Nowadays I mainly opt to reinvest the monthly repayments I receive from Kuflink, which has the effect of boosting the percentage rate of return on the projects in question

Obviously a possible drawback with Kuflink and similar platforms is that your money is tied up in bricks and mortar, so not as easily accessible as cash savings or even (to some extent) shares. They do, however, have a secondary market on which you can offer any loan part for sale (as long as the loan in question is performing and not in arrears). Clearly that does depend on someone else wanting to buy it, but my experience has been that any loan parts offered are typically snapped up very quickly. So if an urgent need arises, withdrawing your money (or part of it) is unlikely to be an issue.

You can read my full Kuflink review here. They offer a variety of investment options, including a tax-free IFISA paying up to 7% interest per year with built-in automatic diversification. Alternatively you can now build your own IFISA, with most loans on the platform (including the one shown above) being IFISA-eligible.

My investment in European crowdlending platform Nibble continues to perform as advertised. My latest investment was in their Legal Strategy. These are loans that are in default and facing legal action. Nibble buy these loans at a heavily discounted rate and then seek to recover as much as possible of the money owed. The minimum investment is 10 euros and the minimum period is six months. I invested 100 euros for 12 months initially at a target annual interest rate of 12.5%.

The Legal Strategy comes with a deposit-back guarantee. This is a guarantee to return the full investment amount at the end of the investment period and a minimum yield of 9% per year. The actual yield depends on how successful recovery efforts prove, so in practice you may end up with a return of anywhere between 9% and 14.5%. All has gone to plan so far, but I will obviously continue to report on this in the months ahead.

You can read my updated review of Nibble here if you like. You can also sign up directly on the Nibble website [affiliate link].

Moving on, I had another article published on the always-excellent Mouthy Money website. This one is entitled My Odd Smart Meter Story and Why Despite This I Still Recommend Them. In the article I discuss my rather strange experiences with a smart meter, which stopped working after I switched supplier and then rather mysteriously started again two years later! As per the article title, I do still recommend getting a smart meter, especially in these times of soaring energy bills.

Also in September I enjoyed a final (probably) short break of the year in Barmouth in Wales. I stayed at a Victorian Gothic hotel called Tyr Graig Castle. I was lucky with the weather, and enjoyed visiting nearby Harlech and Portmeirion (see cover image) as well as Barmouth itself.

I shall be publishing a full review of my short break in Barmouth soon. In the meantime, here is a photo of a rather splendid sunset taken from the hotel restaurant…

Finally, I know a lot of people are extremely anxious about the cost-of-living crisis. As I said last time, though, it’s important not to panic. I recommend a three pronged-approach of maximizing your income, minimizing your expenditure, and budgeting carefully (using your resources as effectively as possible, in other words).

Bear in mind, also, that a range of government support measures have been announced to mitigate the worst effects of the crisis. This government Help for Households website has a useful summary of all the help available and is regularly updated.

In the meantime, please do check out some of the other posts on Pounds and Sense for additional advice and resources, especially in the Making Money and Saving Money categories.

That’s all for today. As always, if you have any comments or queries, feel free to leave them below. I am always delighted to hear from PAS readers

Disclaimer: I am not a qualified financial adviser and nothing in this blog post should be construed as personal financial advice. Everyone should do their own ‘due diligence’ before investing and seek professional advice if in any doubt how best to proceed. All investing carries a risk of loss.

Note also that posts may include affiliate links. If you click through and perform a qualifying transaction, I may receive a commission for introducing you. This will not affect the product or service you receive or the terms you are offered, but it does help support me in publishing PAS and paying my bills. Thank you!

If you enjoyed this post, please link to it on your own blog or social media: