Business, 11.02.2020 18:08 Bubbyd121503
Assume that your parents wanted to have $160,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and earned 8% per year on their investments. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section.
a. How much would they have to save each year to reach their goal?
b. If they think you will take five years instead of four to graduate and decide to have $200,000 saved just in case, how much would they have to save each year to reach their new goal? $
c. How much would they have to save each year to reach their goal?
d. If they think you will take five years instead of four to graduate and decide to have $200,000 saved just in case, how much would they have to save each year to reach their new goal?
In cell D14, by using cell references, calculate the amount to save under the first scenario (1 pt.). Note: The output of the expression or function you typed in this cell is expected as a positive number. In cell D20, by using cell references, calculate the amount to save under the second scenario (1 pt.). Note: The output of the expression or function you typed in this cell is expected as a positive number.
Answers: 1
Another question on Business
Business, 22.06.2019 05:30
The struter partnership has total partners’ equity of $510,000, which is made up of main, capital, $400,000, and frist, capital, $110,000. the partners share net income and loss in a ratio of 80% to main and 20% to frist. on november 1, adison is admitted to the partnership and given a 15% interest in equity and a 15% share in any income and loss. prepare journal entries to record the admission of adison for a 15% interest in the equity and a 15% share in any income and loss under the following independent assumptions. (1) record the admission of adison with an investment of $90,000 for a 15% interest in the equity and a 15% share in any income and loss. (2) record the admission of adison with an investment of $120,000 for a 15% interest in the equity and a 15% share in any income and loss. (3) record the admission of adison with an investment of $80,000 for a 15% interest in the equity and a 15% share in any income and loss.
Answers: 1
Business, 22.06.2019 12:00
Areal estate agent is considering changing her cell phone plan. there are three plans to choose from, all of which involve a monthly service charge of $20. plan a has a cost of $.42 a minute for daytime calls and $.17 a minute for evening calls. plan b has a charge of $.52 a minute for daytime calls and $.15 a minute for evening calls. plan c has a flat rate of $80 with 275 minutes of calls allowed per month and a charge of $.38 per minute beyond that, day or evening.a. determine the total charge under each plan for this case: 150 minutes of day calls and 70 minutes of evening calls in a month. (do not round intermediate calculations. round your answer to 2 decimal places. omit the "$" sign in your response.)c. if the agent will use the service for daytime calls, over what range of call minutes will each plan be optimal? (round each answer to the nearest whole number.include the indifference point itself in each answer.)d. suppose that the agent expects both daytime and evening calls. at what point (i.e., percentage of total call minutes used for daytime calls) would she be indifferent between plans a and b?
Answers: 1
Business, 23.06.2019 02:20
Speedy auto repairs uses a job-order costing system. the company’s direct materials consist of replacement parts installed in customer vehicles, and its direct labor consists of the mechanics’ hourly wages. speedy’s overhead costs include various items, such as the shop manager’s salary, depreciation of equipment, utilities, insurance, and magazine subscriptions and refreshments for the waiting room. the company applies all of its overhead costs to jobs based on direct labor-hours. at the beginning of the year, it made the following estimates: direct labor-hours required to support estimated output 20,000 fixed overhead cost $ 350,000 variable overhead cost per direct labor-hour $ 1.00 required: 1. compute the predetermined overhead rate. 2. during the year, mr. wilkes brought in his vehicle to replace his brakes, spark plugs, and tires. the following information was available with respect to his job: direct materials $ 590 direct labor cost $ 109 direct labor-hours used 6
Answers: 1
Business, 23.06.2019 09:00
Jonathan’s class has 30 boys. of the students in his class, 60% are girls. how many girls are in jonathan’s class? (a)75 (b)60 (c)45 (d)20
Answers: 1
You know the right answer?
Assume that your parents wanted to have $160,000 saved for college by your 18th birthday and they st...
Questions
Computers and Technology, 31.07.2019 10:30
Mathematics, 31.07.2019 10:30
Spanish, 31.07.2019 10:30
English, 31.07.2019 10:30
