Company Name Purchases Inventory, 12/31/23 Tax INPUT SECTION... Other: Rev/Exp/Gain() CHANGE in Retained Earnings FYE 12/31/23 (+/-) Purchases Adjustments as a % of Net Purchases Cost of Goods Sold as a % of Cost of Goods Available Freight-In as a % of Purchases Adjustments Tax Rate Operating Expenses as a % of Inventory, 1/1/23 Sales as a % of Sales Adjustments Preferred Dividends as a % of Common Dividends Retained Earnings, 12/31/23 as a % of Operating Income Weighted Average Common Shares Outstanding Name World Series, Inc. Amount (5) $5,400,000 $2,100,000 $1,600,000 -$ 500,000 $1,900,000 Amount (%) 12.50 75.00 150.00 40.00 200.00 1,000.00 80.00 Amount (shares) 876,000
- Work the problem out by hand on a piece of paper so that you know what the answers should be. All dollar amounts (except EPS) should end in ",000"
- The schedule and statment in your output should compute mathematically from TOP to Bottom, so check and make sure that's the case
- Math Example: If A - B = C, then A - C = B and A = B + C
Prepare an output section that produces the following items: 1) "COGS Schedule", 2) "Income Statement", and 3) "
Prepare a data input section in the exact order as given below. Naming of the input 'sheet' should be "INPUT". Do NOT cellprotect the numeric data of this section, as you must allow for the possibility of change to this information. Use the amounts given as a test of your output. Enter Pct as the %, not decimal (80% entered as 80, not 0.80). Your input should be placed in the following Rows [1-24]/Columns [A-B], with the heading "... INPUT SECTION ..." centered over all columns to which it relates:
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images