Recreate this Table in excel. Table 7.8 Spreadsheet Kappa's Working Capital Requirements Working Capital Days Assets 1

Recreate this Table in excel.
 

Transcribed Image Text:

Table 7.8 Spreadsheet Kappa's Working Capital Requirements Working Capital Days Assets 1 Accounts Receivable 2 Raw Materials 3 Finished Goods 4 Minimum Cash Balance Liabilities 5 Wages Payable 6 Other Accounts Payable Based on: Sales Revenue Raw Materials Costs Raw Materials + Labor Costs Sales Revenue Year Direct Labor + Admin Costs Raw Materials + Sales and Marketing 2021 Days 90 45 45 30 15 45 >2021 Days 60 30 45 30 15 45 Table 7.8 Spreadsheet Kappa's Working Capital Requirements Working Capital Days Assets 1 Accounts Receivable 2 Raw Materials 3 Finished Goods 4 Minimum Cash Balance Liabilities 5 Wages Payable 6 Other Accounts Payable Based on: Sales Revenue Raw Materials Costs Raw Materials + Labor Costs Sales Revenue Year Direct Labor + Admin Costs Raw Materials + Sales and Marketing 2021 Days 90 45 45 30 15 45 >2021 Days 60 30 45 30 15 45

Answer rating: 100% (QA)

Question Net Working Capital Requirement for ... View the full answer