At the beginning of year 1, your auto-insurance premium for the next year is $300. if you have 0 accidents in a year your premium for the next year drops 10 percent, if you have 1 accident in a year your premium for the next year increases10 percent, and if you have 2 accidents in a year your premium for the next year increases 30 percent. set up a spreadsheet that will determine the premium cost for years 1–30. (hint: # of accidents are up to you. idea is to create an if formula that will return the correct auto insurance premium in each year for any number of accidents.)

Ms. sophia jones, the company president, has heard that there are multiple breakeven points for every product. she does not believe this and has asked you to provide the evidence of such a possibility. some information about the company for 2017 is as follows:

Suppose that jim plans to borrow money for an education at texas a& m university. jim will need to borrow $25,000 at the end of each year for the next five years (total=$125,000). jim wishes his parents could pay for his education but they can’t. at least, he qualifies for government loans with a reduced interest rate while he is in school. he has a special arrangement with aggiebank to lend him the money at a subsidized rate of 1% over five years without having to make a payment until the end of the fifth year. however, at the end of the fifth year, jim agrees to pay off the loan by borrowing from longhorn bank. longhorn bank will lend him the money he needs at an annual interest rate of 6%. jim agrees to pay back the longhorn bank with 20 annual payments and the payments will be uniform (equal annual payments including principal and interest). (i) calculate how much money jim has to borrow at the end of 5 years to pay off the loan with aggiebank. a. $121,336 b. $127,525 c. $125,000 d. $102,020 e. none of the above

Asmartphone manufacturing company uses social media to achieve different business objectives. match each social media activity of the company to the objective it the company achieve.