Stman publishing company is considering publishing an electronic textbook about spreadsheet applications for business. the fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $160,000. variable processing costs are estimated to be $6 per book. the publisher plans to sell single-user access to the book for $46. (a) build a spreadsheet model in excel to calculate the profit/loss for a given demand. what profit can be anticipated with a demand of 3,500 copies

Over the past several years, joyce chen has been able to save regularly. as a result, today she has $54,188 in savings and investments. she wants to establish her own business in 5 years and feels she will need $100,000 to do so. a. if she can earn 6% on her money, how much will her $54,188 in savings/investments be worth in 5 years? will joyce have the $100,000 she needs? if not, how much more money will she need? b. given your answer to part a, how much will joyce have to save each year over the next 5 years to accumulate the additional money? assume she can earn interest at a rate of 6%. c. if joyce can afford to save only $4,000 a year then, given your answer to part a, will she have the $100,000 she needs to start her own business in 5 years?