Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need help with income tax and net income ..

i need help with income tax and net income ...

50.1K

Verified Solution

Question

Accounting

i need help with income tax and net income
image
image
image
8 9 How: Create a proforma (What if Income Statement in which: 10 1. 11 a. the user only has to enter a value for Sales in cell D3. b. then the spreadsheet will calculate all other expenses and Net Income. Net Income will appear in cell D18. 12 13 2. Enter $300k, $400k, $500k, $600k for Sales Values in cell D3. Then record the Net Income results in cells D21 - D24. 14 15 Assume: 16 1. Variable Costs (change when sales increase) are: 17 a. Cost of Sales, 30% of Sales 18 b. Labor, 22% of Sales 19 c. Misc Operating costs, 12% of sales 20 2 Fixed Costs are: 21 a. Salaries, $38,000 22 b. Office Expense, $18,000 23 C. Depreciaton Expense, $24,000 24 d. Utilities Expense, $6,500 25 e. Property Tax, $4,500 26 3. 27 Assume Income Tax is 30% of Income before taxes. 28 Cor Home Insert Page Layout Formats Data Review View Help X ft 159000 D B F G E 300,000

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

What do illusions tell us about sensory processing? What is the role of proprioception in control...

Biology
Q

Roy Reds Ltd is a Manufacturing Company.The Following Ledger account balances were extracted from the books...

Accounting
Q

1 Calculate the amount of energy needed to break a drop of petrol of volume...

Physics
Q

A particle of mass 0 2 kg oscillates according to the law x 0 08...

Physics
Q

Question 10 Points 1 The matching angles of two triangles are called O base angles...

Geometry
Q

Solve, using a proportion.If a 6-lb. turkey takes120 minutes to cook, how longwould a 9-lb....

Basic Math
Q

Find the mass of the thin bar with the given density function p x 4...

Calculus
Q

81 log 147 log 3 B 3 C 2 logs 8 A 4 D 1

Algebra
Q

the first step in preparing the production cost report is to a. account for the...

Accounting
Q

Within each region, what was the most profitable state in the most recent year, as...

Accounting
Q

85% prices $380,000 Instrucciones 2 y 4 (Balance Sheet) Problem 3-3...

Accounting
Q

Look at the tabel showing return of stock X and stock Y in three scenarios...

Finance