Finance

Ask a Finance Question, Get an Answer ASAP!

this is for "Shawn Adamo" Need help with a chart

Answered by:Shawn P Adamo
CPA, PFS, QFP, CGMA
Positive Feedback: 97.2 %
Accepted Answers: 209

in Finance

Recent Feedback

Positive

I am impressed with the knowledge of experts available in justanswer.com, Thanks...

Customer Question

this is for "Shawn Adamo" Need help with a chart

Submitted: 356 days and 5 hours ago.

Category: Finance

Value: $30

Status: CLOSED

Accepted Answer

Expert: Shawn P Adamo replied 356 days and 5 hours ago.

Shawn P Adamo :

Hello. My specialty is focusing on YOUR Financial needs. Financial Planner/Business Owner for 20 years. CPA,PFS,QFP,GMMA.

Shawn P Adamo :

working on it now

Customer :

sounds good. Again, thank you.

Shawn P Adamo :

Finance

Shawn P Adamo :

Chad

Shawn P Adamo :

click on CHAD.

Shawn P Adamo :

F and U are for part 3

Customer :

is that the first one that is showing?

Customer :

this is kind of confusing

Customer :

if you could better explain this I would greatly appreciate it.

Shawn P Adamo :

1. See net sales?

Shawn P Adamo :

can you join me?

Customer :

i am back. Sorry

Customer :

Shawn are you there?

Shawn P Adamo :

yes. i'm back

Shawn P Adamo :

sorry.

Customer :

thats ok

Customer :

now if you can explain this to me that would be awesome

Shawn P Adamo :

see net sales?

Customer :

yes

Shawn P Adamo :

see how it sent UP from 3146 to 3276?

Customer :

yes

Shawn P Adamo :

the diff - increase ia 130,400

Shawn P Adamo :

130400/3146400=4.1%

Shawn P Adamo :

is it good or bad if sales increase from 2007 to year 2008?

Customer :

I would say good!

Shawn P Adamo :

correct. F=favorable

Shawn P Adamo :

the F is for part 3 of this assignment

Shawn P Adamo :

look at interest expense

Customer :

oh ok. Thats where I was kinda getting confused.

Shawn P Adamo :

it went up. Bad. Unfavorable..increased expense.

Shawn P Adamo :

U=Unfavorable

Shawn P Adamo :

so far so good with the changes from 2007 to year 2008? amounts and %

Shawn P Adamo :

Customer :

ok. I see that you have down arrows. Is that meaning a negative?

Shawn P Adamo :

on the common -size?

Shawn P Adamo :

sorry. No those arrows just mean decrease

Shawn P Adamo :

selling expense went down, but that's a good thing to happen. You are spending less.

Customer :

true. Also I noticed that you had something on part 2 about shift down?

Shawn P Adamo :

if a good thing (income) increases that great. If a good thing (sales) decreases it's bad.

Shawn P Adamo :

operating exp line should be blank

Shawn P Adamo :

move those down 1 line

Shawn P Adamo :

I started on the wrong line

Shawn P Adamo :

In 2007net sales is 100%

Shawn P Adamo :

cogs = 2,008,400

Customer :

so the operating expense should not have anything in there?

Shawn P Adamo :

2,008,400/3,146,400=36.8%

Shawn P Adamo :

correct blank on the operating exp line

Shawn P Adamo :

dee how it is blank on the income stmt

Shawn P Adamo :

Here, on the common size it's all a % of net sales

Customer :

yes the 4.2 and 3.2 should be there correct?

Shawn P Adamo :

yes, for net income

Shawn P Adamo :

each asset is a % of total assets cash/total assets 40,800/1.584,800 2.6

Customer :

oh ok. Do you plan on being on later tonight?

Shawn P Adamo :

probably.

Shawn P Adamo :

does it make more sense now?

Customer :

I am going to plug all of these numbers in and if I have questions I will ask. As I mentioned I have another one that is similar to this that I would like your help with.

Customer :

It does make more sense

Shawn P Adamo :

NP. I'll leave you to accept

Customer :

sounds good. Thanks for all of your help. I will look for you tonight and hopefully get that 2nd one over to you.

Shawn P Adamo :

here.

Customer :

On the first set. You have admin expenses with 5.7% with no increase or decrease

Customer :

and a few below that as well. Just curious about that

Shawn P Adamo :

24,000 increase

Shawn P Adamo :

5.7% increase not ()

Shawn P Adamo :

()= decrease

Shawn P Adamo :

only selling exp and total operating exp decreased

Customer :

so that would be an increase then?

Customer :

just not sure if I should put it as an increase or not or just leave it the way you wrote it

Shawn P Adamo :

yes. in 2007 admin exp was 423,200. In 2008 it was more 447,200. it went UP 24,000

Shawn P Adamo :

put a + next to ALL the changes that went up.

Customer :

ok. Thank you

Shawn P Adamo :

put () around the word (decrease)

Shawn P Adamo :

at top of column

Shawn P Adamo :

on PPE - bottom of page- no brackets around the 30,000. it was an increase

Customer :

property plant and equipment?

Shawn P Adamo :

yes

Customer :

ok. Any others that I need to watch for

Shawn P Adamo :

Customer :

if you didn't put a (-) it will be a +?

Shawn P Adamo :

yes

Shawn P Adamo :

back in a bit.

Customer :

you still there

Shawn P Adamo :

ll leave this chat open

Customer :

Hi. Can I please send you what I have completed so you can take a look at it?

Shawn P Adamo :

sure

Customer :

ok. Just give me a minute or so.

Shawn P Adamo :

Customer :

Sorry am uploading it right nwo

Shawn P Adamo :

Customer :

http://www.mediafire.com/view/?rb682qmp65pi39i

Customer :

any suggestions would be great.

Customer :

I just want to see if someone else can understand it

Shawn P Adamo :

inventory went DOWN.. D

Shawn P Adamo :

594 down to 574

Shawn P Adamo :

put - sign o in front of selling exp and total operating exp

Shawn P Adamo :

PPE ia a 30,000 INCREASE

Shawn P Adamo :

forgot RE

Shawn P Adamo :

forgot SE

Shawn P Adamo :

correct, do next part and load so i can see it. thx

Shawn P Adamo :

back later

Customer :

Shawn, I'm sorry but I don't understand on what you mean by put - sign o in front of selling exp and total operating exp. I see what area your talking about but I don't understand the sign.

Customer :

I am ready to send you the rest of it to have you look at it.

Customer :

http://www.mediafire.com/view/?vjtpg3sjocdg3dq

Customer :

is the link when your ready

Shawn P Adamo :

put a negative sign in front of the # XX show a decrease

Customer :

for total operating expense?

Customer :

ok gotcha.

Customer :

did the 2nd link I sent load ok for you?

Customer :

and I know that group 1&2 are favorable or unfavorable. Just curious where you think I need to type in the F or U

Shawn P Adamo :

see how you put -20,000 for invntory? make selling exp -41,200

Customer :

I mean part 3

Shawn P Adamo :

might have to retype in section 3

Shawn P Adamo :

make 17,200 into -17,200 1st part

Shawn P Adamo :

change that -30,000 into 30,000 on PPE

Shawn P Adamo :

add % signs to PPE part 2

Shawn P Adamo :

please accept.

Expert Type	CPA, PFS, QFP, CGMA
Category:	Finance
Pos. Feedback:	97.2 %
Accepts:	209
Answered:	5/10/2012

Experience: CPA, PFS, QFP, CGMA

Ask this Expert a Question >

5 Financial Professionals are Online Right Now

Finance Questions	Date Submitted
10.3 General Consulting plc has four divisions, whose summary	4/18/2013
I need to find a loan for preferably $5,000-$10,000. Any recomendations	4/16/2013
DEAR BILL (FINANCE),I PURCHASED A SINGLE FAMILY HOME IN DE	4/16/2013
NA-112	4/16/2013
I sold my car about 9 months ago - there is finance outstanding	4/16/2013
I am not one to listen to rumors on the Iraqi dinar, but is	4/13/2013
How can I find out if and/or when Washington Mutual Bank stock	4/11/2013
1. The overall goal of the financial manager is to _________________.	4/7/2013
I have a problem with end of year PAYE National insurance contributions	4/6/2013
I have a student loan that I thought I was making extra principal	4/5/2013