Question: please i need detaild answer with explaination as this answer should be done in Excel Q6.4 (Oscar's Office Building) Oscar is considering getting into the

please i need detaild answer with explaination as
please i need detaild answer with explaination as this answer should be done in Excel
Q6.4 (Oscar's Office Building) Oscar is considering getting into the real estate business. He's looking at buying an existing office building for $1.8 million in cash. He wants to estimate what his return on invested capital (ROIC) will be on an annual basis. The building has 14,000 square feet of rentable space. He'd like to set the rent at $4.00 per square foot per month. However, he knows that demand depends on price. He estimates that the percent- age of the building he can fill roughly follows the equation % Occupied = 2-0.3 x Rent I (rent is in dollars per square foot per month) So, at $4.00, Oscar thinks he can fill about 80 percent of the office space. Oscar considers two categories of costs: variable costs, which are a function of the square feet occupied, and fixed costs. Fixed costs will be $8,000 per month and include such items as insurance, maintenance, and security. Variable costs cover such things as electricity and heat and run $1.25 per month for each square foot occupied. a. Draw an ROIC (return on invested capital) tree for the company. [6.2] b. What is the ROIC? [6.2] c. What would be the new ROIC be if Oscar decides to charge rent of $5.00 per square foot per month? [6.3)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!