Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would like to withdraw $90,000 per year (in monthly installments) from an investment account for a twenty-five year retirement. At the end of his retirement, he would like to leave a bequest of $100,000 to his heirs. He currently has $10,000 in his investment account for these purposes. Stan plans to save for retirement by making monthly deposits into the investment account, beginning two years from now and ending the month before he retires. The investment account pays 9 percent compounded monthly. Construct a flexible spreadsheet model to answer the following questions:
1. How much must Stan invest each month to accomplish his retirement goals?
2. If Stan's employer will contribute $0.50 for every $1.00 he invests, how much of the deposit in #1 will Stan have to contribute?

Answers

Answer 1

Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would like to withdraw 90,000 per year (in monthly installments) from an investment account for a twenty-five year retirement. At the end of his retirement, he would like to leave a bequest of90,000peryear(inmonthlyinstallments)fromaninvestmentaccountforatwenty−fiveyearretirement.Attheendofhisretirement,hewouldliketoleaveabequestof100,000 to his heirs. He currently has $10,000 in his investment account for these purposes. Stan plans to save for retirement by making monthly deposits into the investment account, beginning two years from now and ending the month before he retires. The investment account pays 9 percent compounded monthly. Construct a flexible spreadsheet model to answer the following questions:

1. How much must Stan invest each month to accomplish his retirement goals?

2. If Stan's employer will contribute 0.50 for every0.50forevery1.00 he invests, how much of the deposit in #1 will Stan have to contribute?


Related Questions

Economists Mark Blaug and Ruth Towse studied the market for economists in Britain and found that the quantity demanded was about 150 to 200 a year, and that the quantity supplied was about 300 a year. What likely to happen when there is a surplus of economists in Britain

Answers

Answer: See explanation

Explanation:

In this case, since the supply is more than the demand for Economists in the country, this will lead to a lower wage for the Economists that are employed. This is because there are surplus Economists which can be readily called if those employed aren't willing to collect the lower wages.

Also, the excess Economists can move to other countries where their services will be needed. In some cases, they may take jobs that are similar to their practice such as researchers, marketing roles etc.

Elite Trailer Parks has an operating profit of $200,000. Interest expense for the year was $10,000; preferred dividends paid were $18,750; and common dividends paid were $30,000. The tax was $61,250. The firm has 20,000 shares of common stock outstanding.

Required:
a. Calculate the earnings per share and the common dividends per share for Elite Trailer Parks.
b. What was the increase in retained earnings for the year?

Answers

Answer:

a. Earnings per share = (Operating profit - Interest expense - Tax - Preferred dividends) / Common stock outstanding

Earnings per share = ($200,000 - $10,000 - $61,250 - $18,750) / $20,000

Earnings per share = $110,000 / 20,000 Shares

Earnings per share = $5.5 per share

Common dividends per share = Dividend paid / Common stock outstanding

Common dividends per share = $30,000 / 20,000 Shares

Common dividends per share = $1.50 per share

b. What was the increase in retained earnings for the year?

Increase in retained earnings = $110,000 - Common dividend paid

Increase in retained earnings = $110,000 - $30,000

Increase in retained earnings = $80,000

So,  the increase in retained earnings for the year is $80,000.

Lynx Corp. The data presented below for Lynx Corp. are for the year ended December 31, 2017: Sales (100% on credit) $1,000,000 Sales returns 30,000 Accounts receivable (December 31, 2017) 170,000 Allowance for doubtful accounts (credit balance) (before adjustment at December 31, 2017) 1,300 Estimated amount of uncollectible accounts based on aging analysis 14,000 See the data for Lynx Corp. If Lynx Corp. uses the aging of accounts receivable approach to estimate its bad debts, what amount will be reported as bad debts expense for 2017

Answers

Answer:

Allowance for Doubtful Accounts 69,000

Explanation:

If the company estimates its bad debt to be 2% of net credit sales:

sales                        2,500,000

return and allowance (50,000)

               net sales 2,450,000

Then, we calculate 2% of this amount:

2,450,000 x 0.02 = 49,000

As the uncollectible amounts are related to sales rather than account receivable we adjust for the full value giving an ending value of:

beginning 20,000 + adjustment 49,000 = 69,000

Automation Services Co. offers its services to companies desiring to use technology to improve their operations. After the accounts have been adjusted at December 31, the end of the fiscal year, the following balances were taken from the ledger of Automation Services: Fees Earned $614,500 Dividends 45,000 Rent Expense 140,000 Retained Earnings 3,250,000 Supplies Expense 18,200 Wages Expense 320,000 Miscellaneous Expense 8,700
Journalize the closing entries.

Answers

Answer and Explanation:

The journal entries are shown below:

1  Fees Earned  $614,500

        To Income Summary A/c  $614,500

(Being the closing of revenue accounts is recorded)

2

Income Summary A/c  $486,900  

  To Rent Expenses A/c  $140,000  

  To Supplies Expense A/c  $18,200

   To Wages Expenses A/c  $320,000  

  To Miscellaneous Expenses A/c  $8,700

(Being the closing of expenses accounts is recorded)

3

Income Summary A/c  $127,600 ($614,500 - $486,900)  

  To Retained Earnings A/c  $127,600

(Being the closing of the income summary is recorded)

4

Retained Earnings A/c  $45,000

  To Dividends A/c  $45,000

[Being the closing of the Dividend account is recorded]

You are holding a stock that has a beta of 1.39 and is currently in equilibrium. The required return on the stock is 20.47%, and the expected return on the market portfolio is 16.50%. What would be the expected return on the stock if the expected market return increased to 21.00% while the risk-free rate and beta remained unchanged

Answers

Answer: 26.73%

Explanation:

You can calculate the expected return using the Capital Asset Pricing Model (CAPM).

Formula is:

Expected return = Risk free rate + beta * (Market return - risk free rate)

Use the previous figures to solve for the risk free rate:

20.47% = Rf + 1.39 * (16.50% - Rf)

20.47% = Rf + 22.935% - 1.39R

20.47% - 22.935% = Rf - 1.39Rf

-2.465% = -0.39Rf

Rf = -2.465% / -0.39

= 6.32%

New expected return is:

= 6.32% + 1.39 * (21% - 6.32%)

= 26.73%

If you have a choice to earn simple interest on $10,000 for three years at 8% or annually compounded interest at 7.5% for three years which one will pay more and by how much

Answers

Answer:

The compound interest will yield $22.97 more than simple interest.

Explanation:

Giving the following information:

Initial investment (PV)= $10,000

Interest rate (r)= 8% simple interest

Interest rate (i)= 7.5% compound interest

Number of periods= 3 years

To calculate the future value of both options, we need to use the following formulas:

Simple interest:

FV= PV*r*t + PV

FV= 10,000*0.08*3 + 10,000

FV= $12,400

Compound interest:

FV= PV*(1 + i)^t

FV= 10,000*(1.075^3)

FV= $12,422.97

The compound interest will yield $22.97 more than simple interest.

It costs Waterway Company $18.00 of variable costs and $7.80 of fixed costs to produce its product that sells for $40. Carla Vista Company, a foreign buyer, offers to purchase 3100 units at $23.50 each. If the special offer is accepted and produced with unused capacity, net income will:

Answers

Answer:

Increase by $17,050

Explanation:

In our analysis, we will use the incremental revenue and cost only. That means we exclude fixed costs since they are irrelevant for this decision and are already incurred.

Analysis of effects of accepting the special order

Sales (3,100 units x $23.50)                                               $72,850

Less Variable Costs (3,100 units x $18.00)                      ($55,800)

Financial Advantage / (Disadvantage)                               $17,050

therefore,

If the special offer is accepted and produced with unused capacity, net income will: Increase by $17,050.

The____has sole responsibility for determining if a product or service will be added to the Procurement List and for setting the Fair Market Price

Answers

Answer:

AbilityOne Commission

the most effective use of the interim ___ is to establish cost standards and compare the actual amount with the budgeted amount for that time period

Answers

Answer:

income statement

inventory analysis (w)

Explanation:

metion form of ownership represented by the SABC OF SOUTH AFRICA ​

Answers

Answer:

vbnjjhkhgfx

Explanation:

Vhhjjgddeszff

What's the difference between a Monopoly and Oligopoly market?

Answers

Explanation:

The main difference between monopoly and oligopoly is in the number of firms under consideration.

In Monopoly,  the market witness a situation in which one company alone dominates; in other words, this company produces goods or services without having any close competitors.

While in Oligopoly, not just one but a small group of companies act as the dominant players in the market even though they may produce slightly different products; they thus influence the market a lot reducing the chances of new competitors.

On December 31, the balance in the office supplies account is $1,300. A physical count shows $510 worth of supplies on hand. Required: Prepare the adjusting entry for supplies. Refer to the Chart of Accounts for exact wording of account titles.

Answers

Answer:

Date                    Account title                                               Debit          Credit

December 1        Office Supplies Expense                           $790

                            Office Supplies                                                             $790

Explanation:

Office supplies is an asset but when it is used it should be debited to the office supplies expense account because it becomes an expense that should be catered for in the Income statement.

The office expense that is used for the year is:

= Book balance - Physical inventory

= 1,300 - 510

= $790

Custom Quilters makes decorative comforters, quilted garments, and other products in a small sewing factory. The company expects to make 2,000 comforters during the current year. With respect to the comforters, how would the supervisory salaries be classified

Answers

You would have to divide

What resource driver would you use to allocate occupancy cost to activities, and how much would you allocate to Inspect

Answers

Answer:

Cost drivers of occupancy cost:

Useful Life of Asset

Location of the asset

Lease terms

Explanation:

Cost drivers are the factors that drives the cost. Occupancy cost is the whole life cost of the asset. It is associated with the asset during its life irrespective of asset's performance. These costs include, property taxes, insurance, inspection costs, repairs and maintenance costs and likewise. These cost are allocated to the assets useful life. Some companies also use different cost drivers like location of the asset and its lease terms. These costs are charged as the part of assets cost.

Producers of Ocean Spray cranberry products decided to make Craisins (and dried cranberry snack food) available in convenience stores, supermarkets, and vending machines, it was involved with determining ______ strategy.

Answers

I don’t know what your saying I’m confused I’m sorry

Which type of layout features departments or other functional groupings in which similar activities are performed

Answers

Answer:

Process-oriented.

Explanation:

A functional (departmental) organizational structure is a type of structure used to organize staffs by dividing them into various departments based on their skill set, roles or functions and knowledge.

These departments which are vertically structured may include, finance, IT, sales and marketing, research and development, customer service etc. Also, the various departments are headed by a functional manager who are saddled with the responsibility of overseeing, managing and reporting to the executive management.

Similarly, a type of layout in the manufacturing process that features departments or other functional groupings in which similar activities are performed is generally referred to as being process-oriented.

One of the main advantages of a process-oriented layout is that it mitigates or reduces difficulties associated with material flow variability for a product.

Bramble Corp. has the following costs when producing 100000 units: Variable costs $600000 Fixed costs 900000 An outside supplier is interested in producing the item for Bramble. If the item is produced outside, Bramble could use the released production facilities to make another item that would generate $200000 of net income. At what unit price would Bramble accept the outside supplier’s offer if Bramble wanted to increase net income by $140000?

Answers

Answer:

Bramble Corp.

Unit price at which Bramble would accept the outside supplier's offer

= $14.40

Explanation:

a) Data and Calculations;

Production capacity in units = 100,000

Variable costs =      $600,000

Fixed costs =             900,000

Total costs =         $1,500,000

Target net income    140,000

Total revenue =   $1,640,000

Alternative income (200,000)

Differential revenue $1,440,000 ($1,640,000 - $200,000)

Unit price at which Bramble would accept the outside supplier's offer =

$14.40 ($1,440,000/100,000)

Tim Armstrong was tapped to lead an integrated Yahoo!/AOL subsidiary of Verizon called Oath, and will most likely need to set a new strategic direction. Which of the four principal management functions should he focus on first?

Answers

Answer:

planning

Explanation:

The management process in any organization consists of four main and primary function that the managers of the organization needs to focus and perform. They are :

planningorganizingleadingcontrolling

Planning means to define the performance goals for the company and determining the plans and strategies in order to achieve that goal.

In the context, Tim Amstrong, who leads the integrated Yahoo!/AOL subsidiary is going to set a new strategic direction for the company. For this, he needs to focus on planning new organization goals and form new strategies to achieve them.

Thus he should focus on the planning of the four principal management functions.

The net present value decision rule is: When an asset's expected cash flows yield a positive net present value when discounted at the required rate of return, the asset should be acquired.

a. True
b. False

Answers

Answer: True

Explanation:

Net present value (NPV) simply refers to the difference that is gotten between the present value of the cash inflows and that of the cash outflows over a particular period of time.

The net present value is used in investment planning and capital budgeting to determine the profitability of a project.

Therefore, the correct option is true.

Supposed you have had 10 apples. You gave 4 apples to your friend for Christmas. What portion of the initial amount did you give away? (use similar formatting to the dollar amount, strictly decimals, no other signs or characters)

Answers

Answer:

The portion of the initial amount that was given away is:

= 0.40

Explanation:

a) Data and Calculations:

Number of apples available = 10

Number of those apples given to a friend for Christmas = 4

The portion given away = 4/10 = 0.4

This represents 40% of the whole.

b) The portion given away to the friend for Christmas is a proportion of the whole.  In this case, it represents just 40% of the 10 apples.  This means that only 60% or 0.60 of the original apples are still available or on hand because 40% had been given away.

Sharon would make an adjustment entry to __________ to record the $500 her company received from a customer to perform future services. Suppose that before the adjusting entry, the balance in this account was $2,725. After the adjusting entry, the ending balance will be __________.

Answers

Answer:

the ending balance of the unearned revenue is $3,225

Explanation:

The computation of the ending balance is shown below:

= Amount received from the customer for performing the future service + balance in the account

= $500 + $2,725

= $3,225

Therefore the ending balance of the unearned revenue is $3,225

The above formula should be applied

With the new​ technology, the opportunity cost of producing a chicken​ _____ because​ _____ soybeans must be forgone to produce a chicken.

Answers

The full question is:

A farm grows soybean and produces chickens. The opportunity cost of producing each of these products increases as more of it is produced.

The farm adopts a new technology which allows it to use fewer resources to produce soybean.

With the new​ technology, the opportunity cost of producing a chicken​ _____ because​ _____ soybeans must be forgone to produce a chicken.

Answer:

increases​; more

Explanation:

Opportunity cost is the forgone alternative when a particular line of action is undertaken. For example in the given scenario more production of chicken will lead to loss of soyabean production and vice versa.

So when there is production of more chicken more opportunity cost is incurred because more of soyabean production is forgone in order to produce the chicken.

Economists consider opportunity cost seperately from the actual cost incurred in taking up a particular activity.

ompany X and company Z are planning to merge their business into one and are seeking regulatory approval. What is the most likely reasoning X

Answers

Answer: The newly created firms is able to take advantage of economies of scale.

Explanation:

A merger is an agreement whereby two companies come together and pool their resources together in order to form one company and achieve same organizational goals.

One main reason why companies merge together is in order to achieve economies of scale. This is the reduction in cost as a result of the expansion and increase in production level.

The demand for a certain drug in a hospital has been increasing. For the past six months, the following demand has been observed:
Month Demand, Units
January 15
February 18
March 22
April 23
May 27
June 26
Use a three-month moving average to make a forecast for July.

Answers

Answer:

25.3

Explanation:

A moving average is often used to pinpoint the increase or decrease of a certain statistic over a certain period of time since the increase in the demand for this specific drug has been increasing constantly for the past 6 months we will take the past 3 months, April, May, and June, so we will have to add up 23+27+26=76, now we just have to divide by the number of months= 76/3=25.3, so the moving average for the increase in the forecast for July will be 25.3

R. L. Ybarra employs John Ince at a salary of $53,000 a year. Ybarra is subject to employer Social Security taxes at a rate of 6.2% and Medicare taxes at a rate of 1.45% on John's salary. In addition, Ybarra must pay SUTA tax at a rate of 5.4% and FUTA tax at a rate of 0.8% on the first $7,000 of Ince's salary. Compute the total cost to Ybarra of employing Ince for the year. Round your answer to the nearest cent.

Answers

Answer: $57488.50

Explanation:

The total cost to Ybarra of employing Ince for the year will be calculated thus:

Gross Salary = $53,000

Add: Social security tax = $53000 × 6.2% = $3286

Add: Medicare tax = $53000 × 1.45% = $768.50

Add: SUTA tax = $7000 × 5.4% = $378

Add: FUTA tax = $7000 × 0.8% = $56

Total cost to Ybarra of employing Ince will be $57488.50

The Trade Gravity Model predicts that the volume of trade between two countries increases with the product of the GDP of the two countries and inversely with distance. This prediction is most consistent with: g

Answers

Answer:

The HOS model

Explanation:

Heckscher Ohlin model is the economic model which assumes that there are two countries with two goods and two factors. These countries can trade easily in the market without any barrier. This model explains the pattern of trade of the two countries who wishes to trade the goods they produce in their home country.

Suppose the demand function for a good is expressed as Q=100-4p. If the good currently sells for 10, what is the price elasticity equal to? a)-4 b)-1.5 c) -0.67 d) -2.5

Answers

Answer:

c)-0.67

Explanation:

Calculation to determine what the price elasticity equal to

Using this formula

Price Elasticity of Demand (PED)=dQ/dP*Q/P

Let plug in the formula

Price Elasticity of Demand (PED)=d(100-4p)/dp*p/100-4p

Price Elasticity of Demand (PED)=-4*p/100-4p

at p=$10

Price Elasticity of Demand (PED)=-4*$10/100-4($10)

Price Elasticity of Demand (PED)=-40/60

Price Elasticity of Demand (PED)=-2/3

Price Elasticity of Demand (PED)=-0.666

Price Elasticity of Demand (PED)=-0.67 Approximately

Therefore the price elasticity equal to -0.67

Market leader in the confectionery industry, Jelly Belly, the jelly bean manufacturer, must keep coming up with new flavors. In 2011, it released its Soda Pop Shoppe collection, which was developed after company employees were asked to suggest as many potential new jelly beans tastes as they could without being criticized for any of their ideas, no matter how outlandish. What method did Jelly Belly use to come up with this new product line

Answers

Answer:

brainstorming

Explanation:

In product development different methods can be used to generate the ideas behind a product.

One of them is brainstorming which involves the use of creative ideas from different groups or people.

After ideas are obtained they are discussed, critiqued, and final selection is made.

The given scenario where Soda Pop Shoppe collection was developed after company employees were asked to suggest as many potential new jelly beans tastes as they could without being criticized for any of their ideas, no matter how outlandish. This is brainstorming

a budget is used to do which of the following

Answers

Answer:

A budget is a financial plan used to estimate future income and expenses. The budgeting process may be carried out by individuals or by organizations. Budgets help an entity determine whether it can continue to operate with its projected income and expenses.

Explanation:

thank me later

Explain how the GDP and the interest rate are related to the transactions demand and asset demand for money.

Answers

Answer:

Transaction demand rises as income or GDp rises and falls as income or DP falls. Also high interest rate causes more to be left as asset, thereby reducing money demand

Explanation:

1. Asset demand for money is money that is kept aside for a person holding it to earn interest on. A high interest rate on money asset reduces the demand for money. This increased rate of interest is the opportunity cost of having money as assets. It has a negative relationship with interest rate of an economy.

2. Transaction money is that which is used for the day to day expenditure. This has a positive relationship with GDP. It increases as income or GDP increases and falls as it falls.

Other Questions
Homeostasis is maintained through feedback mechanisms.a. Trueb. False What is the m_ACB?O 10B.0 50(4x)O 90O 180(7x-20) A simple random sample of eight high school students' ACT scores gave the following data: What is a point estimate for , the mean test score for the population? a. A point estimate cannot be computed since the data for the whole population are not available. b. 235 c. 29.38 d. 4.84 Please answer correctly !!!!! Will mark Brianliest !!!!!!!!!!!!!! What am I going to do with points? which type of rehetoric is used in the sentence. getting good grades in school will help you get into a better collegeethoslogospathosbias Is HNO3 an acid or a baseI NEED HELP ASAP please show your work Karla bought her dress for the recital not because she liked the color and style, but because it made her feel good about herself, and she needed that confidence before performing. This represents the importance of the ________________ aspect of a product. *DIAGRAM IN PICTURE*The diagram shows the side wall of a shed. Calculate the length of the slopping roof. The shift in this piece occurs when Edwards saysSelect one:a. Therefore, let every one that is out of Christ, now awake and fly from the wrath to come.b. but here you are in the land of the living and in the house of God, and have an opportunity to obtain salvation.c. And now you have an extraordinary opportunity, a day wherein Christ has thrown the door of mercy wide open, and stands in calling and crying with a loud voice to poor sinnersd. How can you rest one moment in such a condition? Are not your souls as precious as the souls of the people at Suffield*, where they are flocking from day to day to Christ? which memory can be removed from motherboard? RAM OR ROM? Jeff sells popcorn for $3 per bag. To make a profit each day, he needs to sell at least $120 worth of popcorn. He has sold $36 worth of popcorn today. Which inequality can be used to find the number of bags of popcorn, p, Jeff still needs to sell today to make a profit?A- 3p - 36_>120B- 3(p+36) _>120C- 3p - 12_>120D- 3p + 36 _> 120PLEASE ANSWER QUICKLY! 10 POINTS!!! Find the missing side of each triangle. Round your answers to the nearest tenth if necessaryPlease explain a step by step reduce 286/858 to simplest terms Given that y2 is directly proportional to the cube of x and y is always positive. Find thevalue of. when x = 3 if y = 18 when x =4A) 27 B) 11.67 C) 29 PLease help!!!! NO LINKS!! Will mark brainliest for right answer!!Which answer below represents the number of solutions the graph of a linear function and a quadratic function could have?A) 2B) 4C) 5D) 3 I really need help no files or links brainly removes itFinding a final amount in a word problem on exponential growth or decayAn amount of $41,000 is borrowed for 9 years at 6.25% interest, compounded annually. If the loan is paid in full at the end of that period, how much must be paid back?Use the calculator provided and round your answer to the nearest dollar What is one thing that you enjoyed the most about guiding children's Behavior and Moral development? Please help The smallest province in Canada is:OntarioBritish ColumbiaQuebecPrince Edward IslandNO WEBSITES OR YOU WILL GET REPORTED