Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please, help me to figure out these questions in excel. if you can post how you use the excel function, it will be great. Your

please, help me to figure out these questions in excel. if you can post how you use the excel function, it will be great.

image text in transcribed

image text in transcribed image text in transcribed

Your firm is reporting the following financial information to its shareholders. Starting with the Financial Impact Template spreadsheet available from http: /www.osem-pro.com/scp, replicate the calculations for net income, return on assets, profit margin, and asset turnover shown in the preceding table. Modify your spreadsheet so that it is capable of calculating changes in net income, return on assets, profit margin, and asset turnover based on percent changes in the various accounts. In the example in the chapter a reduction of materials by 5% and inventory by 4% results in 28.05% change in net income, a 28.69% change in return on assets, a 28.05% change in profit margin, and a 0.50% change in asset turnover. Format your spreadsheet like the following: a) Starting format the "current" financial data, use your spreadsheet to predict changes in the key performance measures for a project that is predicted to reduce labor by 10% and overhead by 5%. b) Your firm is consider a project where assembly would be out-sourced. You estimate that this project would reduce labor cost 4% but increase material cost by 1% Further, you expect that you could reduce your fixed assets by about 10%. Starting from the "current" financial data, what would be the impact of this project on your firm's performance measures? If you were given free choice to develop a new project that focuses on any two financial accounts, what would you focus on if your goal was to improve return on assets. (Assume that you could make 1% improvement in each of these accounts.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ethics In Finance

Authors: John R. Boatright

3rd Edition

1118615824, 978-1118615829

More Books

Students also viewed these Finance questions