Class Activities ctivities Excel Work 1: Profit Leverage Attached Files: Excel 1 - Profit Leverage.xlsx (12.221 KB) With a revenue of $100 million, purchases of $60 million, and profit of $8 million before tax, inventory is valued at $20 million which accounts for 40% of total assets. What effect would a 5% reduction in purchase spend have on: a) Profit b) Profit Margin c) Total Assets d) Investment Turnover e) Return-on-Assets (ROA) What would the reduction be in order to: f) double the profit g) double the ROA Please provide your final answers to parts (a) to (9) and submit your Excel work too. It's fine if your work on part (g) overwrites the answers to the previous parts. Only submit one (and the last) file. You may use the attached template to build your Excel model. 227 AM 8/27/2020 O LA C