PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS In preparing the cash budgeting projected balance method, it is...

PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS

PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS

PLEASE, DO IT IN EXCEL AND SHOW THE FORMULASIn preparing the cash budgeting projected balance method, it is necessary to calculate the amount of the inventory balance. The following information is available for the current fiscal year: Inventory balance, $200,000.00, it is known that the inventory turnover is every 60 days. The Cost of Sales is forecasted to increase 15% for the next fiscal year.What is the budgeted inventory balance