No More Worries!

image Our orders are delivered strictly on time without delay

Paper Formatting

  • Double or single-spaced
  • 1-inch margin
  • 12 Font Arial or Times New Roman
  • 300 words per page

No Lateness!

image Our orders are delivered strictly on time without delay

Our Guarantees

image

  • Free Unlimited revisions
  • Guaranteed Privacy
  • Money Return guarantee
  • Plagiarism Free Writing

Blue Butterfly Company

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:

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.
Demonstrating the future value of the monthly cash investments for the next 10 years given the investment earns the projected 8% annual return.
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.
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.

Sample Solution

levant IT software can relieve pressure save time and increase accuracy however the scope of the role would be far greater. 3.3 Analyse key factors & trends impacting on a school: See Appendix 2: Political: Brexit is causing a lot of uncertainty with our European students and teachers; Brexit could cause a significant reduction in students from across Europe and reduce the diversity in schools also increase in staffing problems due to the lack of teachers from European countries filling in posts, teachers who bring new cultures and approaches to our schools and community. With so much turmoil in the government school policies like the national funding formula has been pushed back. Economic: The rise in the minimum wage enables families to have more disposal income, therefore working extra hours or a second job may not be necessary which enables parents to devote more time to their children’s schooling and activities. Social: Schools are adopting specific behaviours to improve outcomes for disadvantaged pupils, implementing community centered strategies for parent involvement, monitoring of progress and providing individual learning support; schools have systems in place for early identification and intervention. Pupil premium awarded to raise attainment and also different strategies are used to engage with the disadvantaged families to increase parental engagement and improve academic performance. Technological: Smart apps and devices are fast and furious, schools are confronted with challenging issues from online risks such as violation of privacy or fraud, schools are expected to educate children by raising awareness about these risks and how to avoid them, however budget restrictions is causing to be a barrier on latest ICT equipment and software. 3.4 Explain how a range of analytical tools can be used to investigate & address key management issues within a school: Using analytical tools widens the approach of thinking, enabling SBMs to solve a problem, be predictive and be implementable. I believe the aim of using analytical tools is to sharpen the focus of the analysis and to ensure methodical, balanced approach, e.g. SWOT- helps to focus on internal and external factors, which SBMs can use to identify issues as well as barriers and solutions, useful to spot danger and improve weakness. PESTLE tool can be used to analyse various external factors, which impact schools.
PLACE AN ORDER NOW

Price Calculator

Subject:
Type:
Pages/Words:
Single spaced
approx 275 words per page
Urgency:
Level:
Currency:
Total Cost:

12% Discount

image

  • Research Paper Writing
  • Essay Writing
  • Dissertation Writing
  • Thesis Writing

Why Choose Us

image

  • Money Return guarantee
  • Guaranteed Privacy
  • Written by Professionals
  • Paper Written from Scratch
  • Timely Deliveries
  • Free Amendments