Car Inventory You have been tasked with creating an Excel workbook that will allow sales persons the ability to search existing inventory by VIN. They must also be able to define any combination of search criteria that returns a list of results and summary data pertaining to that result set. They have also asked that you create a separate sheet to help them calculate how large of loan they can afford and an amortization schedule for the loan.
Populate Calculated Fields
You need to calculate the number of days each vehicle has been on the lot and if there are any special notes that need to be added to each vehicle. Any vehicle that has been on the lot for more than 200 days is eligible for a special employee bonus if they are able to sell that vehicle. Any vehicle that has been on the lot between 125 and 200 days will earn the seller one raffle ticket in the end of the month $1000 bonus.
a. Open exam2_data and save as Exam2_LastFirst.
b. On the Inventory worksheet, insert a function in H7:H206 to calculate the number of days each vehicle has been on the lot using 1/1/2018 as today’s date.
c. Insert a function in I7:I206 that will display "Bonus Eligible" for cars that have been on the lot more than 200 days, "Raffle Eligible" for cars that have been on the lot between 125 and 200 days, and nothing for the remaining vehicles.

The company financial officer was interested in the average cost of pcs that had been purchased in the past six months. she took a random sample of the price of 10 computers, with the following results. $3,250, $1,127, $2,995, $3,250, $3,445, $3,449, $1,482, $6,120, $3,009, $4,000 what is the iqr?

Calculate the cost of each capital component—in other words, the after-tax cost of debt, the cost of preferred stock (including flotation costs), and the cost of equity (ignoring flotation costs). use both the capm method and the dividend growth approach to find the cost of equity. calculate the cost of new stock using the dividend growth approach. what is the cost of new common stock based on the capm? (hint: find the difference between re and rs as determined by the dividend growth approach and then add that difference to the capm value for rs.)assuming that gao will not issue new equity and will continue to use the same target capital structure, what is the company’s wacc? e. suppose gao is evaluating three projects with the following characteristics. each project has a cost of $1 million. they will all be financed using the target mix of long-term debt, preferred stock, and common equity. the cost of the common equity for each project should be based on the beta estimated for the project. all equity will come from reinvested earnings. equity invested in project a would have a beta of 0.5 and an expected return of 9.0%.equity invested in project b would have a beta of 1.0 and an expected return of 10.0%.equity invested in project c would have a beta of 2.0 and an expected return of 11.0%.analyze the company’s situation, and explain why each project should be accepted or rejected g

*will mark brainliest! * when a company spends resources (labor, money) to give customers "free" items, those costs are called a. investment costs b. economic costs c. scarcity costs d. opportunity costs answer asap!