(Msg. 1) Posted: Sat Feb 02, 2008 1:28 pm
Post subject: P&L Depreciation Calc Problem Add to elertz Archived from groups: microsoft>public>excel>templates (more info?)
Hi--
Just downloaded the ProfitandLossStatement.xls template and am using it on a
Mac (sorry!).
So we depreciate about 35,000 worth of computers purchased in 2004, and I
thought we report every quarter. The depreciation comes out to 1758 per
quarter. At least, that's what I've calculated it to be.
So I put 1758 in the Prior Period column, and 1758 in the Current Period
column. But my calculation under % Change from Prior Period says "FALSE"!
The calculation there is:
=C50+C50+F48=IF(D50=0,"-",D50/B50-1)
So, my questions are, should I actually be reporting depreciation each
quarter? And, of course, if the figures are the same each period, why is the
calc reporting FALSE?
(Msg. 2) Posted: Sun Feb 03, 2008 10:18 pm
Post subject: Re: P&L Depreciation Calc Problem Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You certainly don't need to apologize for using a Mac).
Don't know where you downloaded the template from, but the formula you
list is designed to return either TRUE or FALSE, since there's an
=
sign after F48.
The formula compares the result of
C50+C50+F48
with the result of the IF() function.
In article <C3CA208E.852D5%rlinsurf@nospam.net>,
Jeffrey Ellis <rlinsurf.TakeThisOut@nospam.net> wrote:
> Hi--
>
> Just downloaded the ProfitandLossStatement.xls template and am using it on a
> Mac (sorry!).
>
> So we depreciate about 35,000 worth of computers purchased in 2004, and I
> thought we report every quarter. The depreciation comes out to 1758 per
> quarter. At least, that's what I've calculated it to be.
>
> So I put 1758 in the Prior Period column, and 1758 in the Current Period
> column. But my calculation under % Change from Prior Period says "FALSE"!
>
> The calculation there is:
>
> =C50+C50+F48=IF(D50=0,"-",D50/B50-1)
>
> So, my questions are, should I actually be reporting depreciation each
> quarter? And, of course, if the figures are the same each period, why is the
> calc reporting FALSE?
>
> Obviously, I can't send it out like this.
>
> Anyone?
>
> Thanks!
>
> All My Best,
> Jeffrey
(Msg. 3) Posted: Wed Feb 06, 2008 2:00 pm
Post subject: Re: P&L Depreciation Calc Problem Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
in article jemcgimpsey-96B25E.22183603022008 DeleteThis @news.microsoft.com, JE
McGimpsey at jemcgimpsey DeleteThis @mvps.org wrote on 2/3/08 9:18 PM:
> You certainly don't need to apologize for using a Mac).
Heh, thanks
>
> Don't know where you downloaded the template from,
Got it From MS. Or at least, its the same template you get from them on a PC
but it has to be unpacked on a PC. So here's the direct link:
> but the formula you
> list is designed to return either TRUE or FALSE, since there's an
>
> =
>
> sign after F48.
>
> The formula compares the result of
>
> C50+C50+F48
>
> with the result of the IF() function.
Right. I redownloaded the original and checked. I obviously had screwed up
the calc somehow, and just replaced it with the original.
=IF($D$16=0,"-",D50/$D$16)
Looks like I selected the calc and a bunch of other fields. Now all is well.
All My Best,
Jeffrey
>
>
> In article <C3CA208E.852D5%rlinsurf@nospam.net>,
> Jeffrey Ellis <rlinsurf DeleteThis @nospam.net> wrote:
>
>> Hi--
>>
>> Just downloaded the ProfitandLossStatement.xls template and am using it on a
>> Mac (sorry!).
>>
>> So we depreciate about 35,000 worth of computers purchased in 2004, and I
>> thought we report every quarter. The depreciation comes out to 1758 per
>> quarter. At least, that's what I've calculated it to be.
>>
>> So I put 1758 in the Prior Period column, and 1758 in the Current Period
>> column. But my calculation under % Change from Prior Period says "FALSE"!
>>
>> The calculation there is:
>>
>> =C50+C50+F48=IF(D50=0,"-",D50/B50-1)
>>
>> So, my questions are, should I actually be reporting depreciation each
>> quarter? And, of course, if the figures are the same each period, why is the
>> calc reporting FALSE?
>>
>> Obviously, I can't send it out like this.
>>
>> Anyone?
>>
>> Thanks!
>>
>> All My Best,
>> Jeffrey
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office