Nicole Walker owns a small bakery in Georgia. A friend has asked to partner with her in the business. In order to know if she wants to expand the business, Nicole wants to "run" some computations to better understand the existing business. Budgeted data for the next 12 months includes:

Revenues $600,000
Fixed costs $150,000
Variable costs $425,000

Variable costs will change based on the number of products sold. Use an Excel spreadsheet to compute expected operating income for each of the following scenarios. Please refer to CSU-Global Library (Links to an external site.) for Lynda tutorials on using Microsoft Excel or use the Excel Tutorials link found in the classroom if you need assistance.

A. A 5% increase in contribution margin, but keeping revenues steady,
B. A 5% decrease in fixed costs,
C. A 10% increase in units sold,
D. A 15% increase in units sold and a 5% increase in fixed cost,
E. A 5% decrease in variable costs and a 5% decrease in fixed cost

Suppose that xtel currently is selling at $40 per share. you buy 500 shares using $15,000 of your own money, borrowing the remainder of the purchase price from your broker. the rate on the margin loan is 8%. a. what is the percentage increase in the net worth of your brokerage account if the price of xtel immediately changes to (a) $44; (b) $40; (c) $36? (leave no cells blank - be certain to enter "0" wherever required. negative values should be indicated by a minus sign. round your answers to 2 decimal places.) b. if the maintenance margin is 25%, how low can xtel’s price fall before you get a margin call? (round your answer to 2 decimal places.) c. how would your answer to requirement 2 would change if you had financed the initial purchase with only $10,000 of your own money? (round your answer to 2 decimal places.) d. what is the rate of return on your margined position (assuming again that you invest $15,000 of your own money) if xtel is selling after one year at (a) $44; (b) $40; (c) $36? (negative values should be indicated by a minus sign. round your answers to 2 decimal places.) e. continue to assume that a year has passed. how low can xtel’s price fall before you get a margin call? (round your answer to 2 decimal places.)

Onsider the following subscription behavior information from genie, a web site that provides tools for constructing a family tree (ancestor search). subscriptions cost $9.99 per month, but you are charged for the entire year at the time of purchase. there is a one-year minimum term when you sign up for the service. once purchased, subscriptions are set to renew automatically unless the subscriber cancels them. when a membership renews, it renews for a one-year term and again you are charged for the entire year. there are no variable costs associated with providing this service to an individual customer, but genie does engage in customer relationship activities that they believe will increase customer retention. these customer relationship activities cost genie about $10 per year per customer. based on a sample of 1000 customers that joined genie five years ago, near the time when the company was founded, they were able to determine how many of those customers remained subscribers in the second year, third year etc. based on this information, genie calculated the average annual retention rate to be 20%. genie uses an annual discount rate of 8%. a. last year, genie spent $10,000 placing advertisements on google. genie management believes that these advertisements were responsible for about 300 new subscribers. would you recommend to genie management that they purchase more google ads? b. suppose a newly-introduced loyalty program increases the number of customers that remained to 30%. does this new data change your answer to 9.a? c. do you have any hesitations or concerns about making recommendations to management based on your above estimate of customer lifetime value?

Consider an economy where government expenditures are 10 and total tax revenues are 10. the supply of labor is fixed at 125 and the supply of capital is fixed at 8. the economy is described by the following equations. y k to the power of 1 divided by 3 end exponent l to the power of 2 divided by 3 end exponent c 2.5 + 0.75 ( y - t ) i 10 - 0.5 r the level of private savings is