Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the 2020 sales data to the All Locations worksheet as follows: a. Open the workbook Support_EX19_CS5-8a_2020.xlsx.
b. Return to the All Locations worksheet in the original workbook.
c. In cell Gs, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5).
d. In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number.
e. Fill the range G6:G8 with the formula in cell G5, filling without formatting.
f. Close the workbook Support_EX19_CS5-8a_2020.xlsx.

You and your new australian bride matilda, are applying for a loan and are required to submit a balance sheet with your net worth. you own a 2008 toyota camry that you bought last month for $9,995. the kelly blue book value for this car is $13,995. you owe $8,150 on the car loan for the camry. you pay off your visa credit card every month and have not paid any credit card interest this year. the current visa credit card balance is $3,522, and the next statement is due in 15 days. you have a student loan balance of $6,500. you presently have $425 in your checking account and $1,540 in your savings account. you own 100 shares of ibm stock that you purchased for $85.50 per share. one share of ibm is now selling for $158.42. you own computers and other electronics that you purchased for $4,100 but could probably sell today on e-bay for $1,800. your gross income is $80,000 per year. what is your current net worth? (see wb ch. 2 example 2.3)

How has internet access changed and affected globalization from 2003 to 2013? a ten percent increase in internet access has had little effect on globalization. a twenty percent decrease in internet access has had little effect on globalization. a thirty percent increase in internet access has sped up globalization. a fifty percent decrease in internet access has slowed down globalization.

Cardinal company is considering a project that would require a $2,725,000 investment in equipment with a useful life of five years. at the end of five years, the project would terminate and the equipment would be sold for its salvage value of $400,000. the company’s discount rate is 14%. the project would provide net operating income each year as follows: sales $2,867,000 variable expenses 1,125,000 contribution margin 1,742,000 fixed expenses: advertising, salaries, and other fixed out-of-pocket costs $706,000 depreciation 465,000 total fixed expenses 1,171,000 net operating income $571,000 1. which item(s) in the income statement shown above will not affect cash flows? (you may select more than one answer. single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. any boxes left with a question mark will be automatically graded as incorrect.) (a)sales (b)variable expenses (c) advertising, salaries, and other fixed out-of-pocket costs expenses (d) depreciation expense 2. what are the project’s annual net cash inflows? 3.what is the present value of the project’s annual net cash inflows? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.) 4.what is the present value of the equipment’s salvage value at the end of five years? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.) 5.what is the project’s net present value? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.)