Using cost basis for net worth report

#6 06-05-2008, 09:19 PM

Thanks everyone for your contributions. To stretch the analogy even further,
it looks like I'm using a sledgehammer to crack a walnut. But crack it I
will!

I don't often stray into Microsoft forums, but if any of you guys ever need
to discuss networks, I hang out most days in the Cisco NetPro forum.

Cheers
Kevin Dorrell
Luxembourg

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Dick Watson wrote:
> > One of the * Business * editions which might better accomodate what you are
> > trying to do. Another much better alternative would be to use Excel or even
> > Access. What you are doing is certainly creative but it's kinda from the
> > "when the only tool you have is a hammer, everything starts looking like a
> > nail" school.
> So maybe we could hammer this a different way, if only as a
> challenge.
> If you are entering scout uniforms as stocks, the
> PerformanceByInvestmentType report could be useful.... at least it
> includes cost basis.
> Investing-> InvestingTools-> CapitalGainsEstimator-> GetStarted-> EstimateCapitalGains
> could be interesting to play with.
> Still, as Dick points out, a spreadsheet could be simpler.

#5 06-05-2008, 05:39 PM

In microsoft.public.money, Dick Watson wrote:

- quote -

> One of the * Business * editions which might better accomodate what you are
> trying to do. Another much better alternative would be to use Excel or even
> Access. What you are doing is certainly creative but it's kinda from the
> "when the only tool you have is a hammer, everything starts looking like a
> nail" school.

So maybe we could hammer this a different way, if only as a
challenge.

If you are entering scout uniforms as stocks, the
PerformanceByInvestmentType report could be useful.... at least it
includes cost basis.

Investing-> InvestingTools-> CapitalGainsEstimator-> GetStarted-> EstimateCapitalGains
could be interesting to play with.

Still, as Dick points out, a spreadsheet could be simpler.

#4 06-05-2008, 04:56 PM

Cal got to the issue at hand: a net worth report that did what you ask for
would not be a net worth report.

One of the * Business * editions which might better accomodate what you are
trying to do. Another much better alternative would be to use Excel or even
Access. What you are doing is certainly creative but it's kinda from the
"when the only tool you have is a hammer, everything starts looking like a
nail" school.

"Kevin Dorrell" wrote:

- quote -

> I organise the uniform stores for my local scout group, so I have to keep
> track of what uniforms I have in stock. I am leveraging the "Investments"
> functionality to do this. Of course, when I produce my accounts for the
> committee, I have to value the uniform stocks at the purchase price, which is
> slightly different from the selling price (by an amount that covers the
> shipping charges we pay).
> So the uniform stocks have to be entered on the balance sheet at historic
> cost price.
> I have already found the cost basis on the portfolio, but that means I have
> to generate my accounts report by hand.

#3 06-05-2008, 02:02 PM

I organise the uniform stores for my local scout group, so I have to keep
track of what uniforms I have in stock. I am leveraging the "Investments"
functionality to do this. Of course, when I produce my accounts for the
committee, I have to value the uniform stocks at the purchase price, which is
slightly different from the selling price (by an amount that covers the
shipping charges we pay).

So the uniform stocks have to be entered on the balance sheet at historic
cost price.

I have already found the cost basis on the portfolio, but that means I have
to generate my accounts report by hand.

Kevin.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Kevin Dorrell <Kevin
> Dorrell[at]discussions.microsoft.com> wrote:
> > I would like my "Net Worth" report to show my investments on a cost basis
> > (i.e. at the price I bought them), not as their current price. Is there any
> > way I can do that?
> No. How would that be related to net worth?
> I suggest you consider configuring in the CostBasis column into your
> Portfolio view.

#2 06-05-2008, 01:20 PM

In microsoft.public.money, Kevin Dorrell <Kevin
Dorrell[at]discussions.microsoft.com> wrote:

- quote -

> I would like my "Net Worth" report to show my investments on a cost basis
> (i.e. at the price I bought them), not as their current price. Is there any
> way I can do that?

No. How would that be related to net worth?

I suggest you consider configuring in the CostBasis column into your
Portfolio view.

#1 06-05-2008, 12:42 PM

Oh. That's not very good, is it!

Thanks for the reply though.

Kevin

"Dick Watson" wrote:

- quote -

> No.
> "Kevin Dorrell" <Kevin Dorrell[at]discussions.microsoft.com> wrote in message
> news:79127E17-14EF-403D-833A-E0D672C8D929[at]microsoft.com...
> > I would like my "Net Worth" report to show my investments on a cost basis
> > (i.e. at the price I bought them), not as their current price. Is there
> > any
> > way I can do that?

06-05-2008, 12:24 PM

No.

"Kevin Dorrell" <Kevin Dorrell[at]discussions.microsoft.com> wrote in message
news:79127E17-14EF-403D-833A-E0D672C8D929[at]microsoft.com...
- quote -

> I would like my "Net Worth" report to show my investments on a cost basis
> (i.e. at the price I bought them), not as their current price. Is there
> any
> way I can do that?

#-1 06-05-2008, 07:57 AM

I would like my "Net Worth" report to show my investments on a cost basis
(i.e. at the price I bought them), not as their current price. Is there any
way I can do that?

Similar Threads
Thread	Forum	Replies	Last Post
IRA Cost Basis Tom: I established a new Money (2004) account to track an IRA. How do I set the cost basis of the account (without entering all of the transactions...	Microsoft Money	2	08-06-2004 08:53 PM
cost basis/avg cost per share David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost...	Microsoft Money	2	03-03-2004 11:00 AM
cost basis/avg cost per share David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost...	Microsoft Money	1	03-01-2004 11:26 AM
Cost Basis KemC: Where do I look to find the calculated cost basis. I've selected "Average cost Basis (Double Category)" on the Details page. Don't know where to...	Microsoft Money	1	02-03-2004 03:56 AM
Cost Basis c.c.: Can someone tell me why I cannot choose the "Actual Cost Basis" method of calculating cost basis if I use the Canadian settings? Does this have...	Microsoft Money	1	02-01-2004 02:23 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode