HW3 - Financial Statements TemplateHAN

School: University Of Arizona - Course: ACCT MISC - Subject: Accounting

Class Model, Inc. Receivables% collectedwithin daysOption 1 0%30 0% 65%60 65% 35%90 35% Total:100%Must equal 100% Average days collected:70.5 Payables% paidwithin daysOption 1 85%30 100% Stock Sold$ 10,000
Option 2 100% 0% 0% Option 2 85%
RowSales/Manufacturing/Inventory Forecast 2 Apr-23May-23 3 Sales Forcast 4 Product 1 (Units)- - 5 Total Sales of Product 1($)- - 6 Total COGS of Product 1 ($)- - 7 8 Manufacturing Forecast 9 Product 1 (Units)2525 10 11 Inventory Forecast 12 Product 1 (Units)2550 13 Product 1 ($)$750$1,500 14 15 Backlog 16 Product 1 (Units)- - 17 18 Products Shipped 19 Product 1 (Units)- - 20 Product 1 ($)- - 21 22 Sales Price Per Unit of Product 1$120$120 23 COGS Per Unit of Product 1($30)($30) 24 Operating Expenses($4,000)($4,000) 25 Stock Sold$10,000in the first m
Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23 100100125125100100 $12,000$12,000$15,000$15,000$12,000$12,000 ($3,000)($3,000)($3,750)($3,750)($3,000)($3,000) 75100100125125125 2525- - 2550 $750$750- - $750$1,500 - - $25$25- - 100100100125100100 $12,000$12,000$12,000$15,000$12,000$12,000 $120$120$120$120$120$120 ($30)($30)($30)($30)($30)($30) ($4,000)($4,000)($4,000)($4,000)($4,000)($4,000)

Expert's Answer

Your future, our responsibilty submit your task on time.

Order Now

Need Urgent Academic Assistance?

Get Professional Help at Low Prices!

*
*
*


*

TOP
Order Notification

[variable_1] from [variable_2] has just ordered [variable_3] Assignment [amount] minutes ago.