Business, 20.10.2021 14:00 makennskyee1198

You are currently a financial analyst within Blue Butterfly Company, a small family owned corporation that manufactures magnetic bookmarks. Blue Butterfly management would like to provide a contributory pension plan for five current members of the management team. Management believes they can afford to invest $10,000 per month for the next 10 years. They anticipate the rate of return will be 8%. At the end of the 10 years, they expect retiring employees to start withdrawing from this pension plan. The anticipated longevity after retirement is expected to be 20 years, and management believes the rate of return on the investment to continue through the 20 years of retirement payout. Management has requested your assistance in determining relevant values so they can finalize the components of the pension plan. Instructions
Using Excel, develop a spreadsheet presentation that covers the following:
a. Explain the concept of the time value of money, including the present and future value of $1, and present and future value of an annuity. Explain the difference between the annuity payment at the beginning and the end of the period.
b. Demonstrating the future value of the monthly cash investments for the next 10 years given the investment earns the projected 8% annual return.
c. In Excel, calculate the total monthly payment that can be withdrawn from the investment over 20 years given the anticipated 8% annual rate of return continues to be met through the 20 years of retirement. Provide management the monthly payment amount that will be available to payout in monthly pension amounts.
d. Assuming all five members of management will receive the same monthly annuity payment, provide management the proposed monthly retirement payment that can be offered to these five members of management.
e. Use the built-in cash flow functions in Excel to perform all calculations, explaining in the adjacent cells the values you entered the function.

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 21:20

Reqwest llc agrees to sell one hundred servers to social media networks, inc. the servers, which social media networks expressly requires to have certain amounts of memory, are to be shipped “f.o.b. social media networks distribution center in tampa, fl.” when the servers arrive, social media networks rejects them and informs reqwest, claiming that the servers do not conform to social media networks’ memory requirement. a few hours later, the servers are destroyed in a fire at social media networks’ distribution center. will reqwest succeed in a suit against social media networks for the cost of the goods?

Answers: 3

Answer

Business, 22.06.2019 00:00

1tanner invested $135,000 cash along with office equipment valued at $32,400 in the company in exchange for common stock. 2 the company prepaid $7,200 cash for 12 monthsâ€™ rent for office space. (hint: debit prepaid rent for $7,200.) 3 the company made credit purchases for $16,200 in office equipment and $3,240 in office supplies. payment is due within 10 days. 6 the company completed services for a client and immediately received $2,000 cash. 9 the company completed a $10,800 project for a client, who must pay within 30 days. 13 the company paid $19,440 cash to settle the account payable created on april 3. 19 the company paid $6,000 cash for the premium on a 12-month insurance policy. (hint: debit prepaid insurance for $6,000.) 22 the company received $8,640 cash as partial payment for the work completed on april 9. 25 the company completed work for another client for $2,640 on credit. 28 the company paid $6,200 cash in dividends. 29 the company purchased $1,080 of additional office supplies on credit. 30 the company paid $700 cash for this monthâ€™s utility bill. prepare general journal entries to record these transactions. 2. post the journal entries from part 1 to the ledger accounts.

Answers: 2

Answer

Business, 22.06.2019 08:30

Match the items with the actions necessary to reconcile the bank statement.(there's not just one answer)1. interest credited in bank account2. fee charged by bank for returned check3. checks issued but not deposited4. deposits yet to be crediteda. add to bank statementb. deduct from bank statementc. add to personal statementd. deduct from personal statement

Answers: 2

Answer

Business, 22.06.2019 20:40

Answer the questions about keynesian theory, market economics, and government policy. keynes believed that there were "sticky" wages and that recessions are caused by increases in prices. decreases in supply. decreases in aggregate demand (ad). increases in unemployment. keynes believed the government should increase ad through increased government spending, but not tax cuts. control wages to increase employment because of sticky wages. increase employment through tax cuts only. increase as through tax cuts. increase ad through either increased government spending or tax cuts. intervene when individual markets fail by controlling prices and production.

Answers: 2

Answer

You know the right answer?

You are currently a financial analyst within Blue Butterfly Company, a small family owned corporatio...

Questions