Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

S 231 Project 5 MSS Leave the first cell under 2016 blank (cell G3) then fill in: Cell G4 Cost of Sales: By Constructing a

image text in transcribed

S 231 Project 5 MSS Leave the first cell under 2016 blank (cell G3) then fill in: Cell G4 Cost of Sales: By Constructing a formula to make cell G4 20% (2) of cell G3 Cell G5 Gross: By Constructing a formula to make cell G5 the result of subtracting cell G4 from cell G3 Op Exp: by Constructing a formula to make cell G6 15% (15) of cell G3 Cell G7 OP Income: By Constructing a formula to make G7 the result of subtracting cell G6 from cell G5 Cell G8 Other Income: By constructing a formula to make Cell G8 is 2% (.02) of cell G3 (This is a formula) Cell G9 Interest Exp: By placing the value 75 in cell G9 Cell G10 NPBT: By constructing a formula to make cell G10 the result of adding cell G7 to cell G8 then subtracting G9 from the total Cell G11 Tax: By constructing a formula to make Cell G11 34% (34) of cell e G3 Cell G12 NI: By constructing a formula making cell G12t the result of subtracting cell G11 from G10 Cell G13 EPS: Place the value .o25 in cell G13 The preceding would sumntions the company used to build its pro form

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Just In Time Accounting How To Decrease Costs And Increase Efficiency

Authors: Steven M. Bragg

3rd Edition

0470403721, 978-0470403723

More Books

Students also viewed these Accounting questions

Question

Define psychology and cite its four major goals.

Answered: 1 week ago