Campbellsville University 1&2 Different docs please
1)300 words 2 responses
For this discussion you will describe a current problem at work, or a problem faced by the company of your choice, and choose what medium you will use to describe the problem and solution. You can choose from Excel spreadsheet, Infographic, Influence Chart, or screen capture video.
Essential Activities:
- Watching the video “Three Statement Model (LO2) (6:21)” will assist you in writing this discussion forum.
- Watching the video “How to link the three financial statements in Excel (LO2) (41:42)” will assist you in writing this discussion forum.
- Watching the video “Preparing a Sales Budget (LO3) (2:07)” will assist you in writing this discussion forum.
- Watching the video “Preparing a Production Budget (LO3) (3:43)” will assist you in writing this discussion forum.
- Watching the video “Preparing a Direct Materials Budget (LO3) (3:31)” will assist you in writing this discussion forum.
- Watching the video “Preparing a Direct Labor Budget (LO3) (2:35″)” will assist you in writing this discussion forum.
- Watching the video “Preparing a Manufacturing Overhead Budget (LO3) (2:20)” will assist you in writing this discussion forum.
- Watching the video “Preparing a Selling and Administrative Expense Budget (LO3) 2:40)” will assist you in writing this discussion forum.
- Watching the video “Preparing a Cash Budget (LO3) (3:31)” will assist you in writing this discussion forum.
- Watching the video “Preparing a Budgeted Income Statement (LO3) (2:02)” will assist you in writing this discussion forum.
Notes:
- Please refer to the discussion forum rubric on the start here tab for this assignment.
- Initial discussion forum is due by Wednesday at 11:59 PM EST and responses to two of your classmates are due by Sunday at 11:59 PM EST.
- You must post on at least 3 different days to earn full points.
- Please make sure you respond to the discussion forum question listed above in your initial post.
- Your initial post should include at least 200 words of substantive content, and each reply at least 100 words of substantive content to earn full points.
- Please make sure to include outside sources to support your discussion, and avoid grammatical errors.
- Lastly, please make sure there is enough unique content in each of your posts (following the minimum suggested word counts); for instance if your two replies include mostly the same content you will not earn full points.
2)This is week7
Using the Retirement Planning Model that you created in Excel, write 6-to-9-page paper answering the questions stated in the retirement case study.
For your course project, you will complete the retirement planning case by creating a spreadsheet model in Excel and using the model to answer the case questions. You will also apply the model to your personal situation and write a 6-to-9-page paper. The project will be completed over five weeks and is worth 43% of your grade. A summary of the assignments and points follows:
Week Four: Project Action Plan 50 points
Week Five: Create Influence Chart 50 points
Week Six: Create Model in Excel 75 points
Week Seven: Answer Case Questions 75 points
Week Eight: Course Project Paper 125 points
Essential Activities:
- Reviewing the paper “Financial Modeling Guidelines (LO2) (pages 3-29 only)” will assist you in completing this assignment.
- Watching the video “40% of Americans Say THIS is How Much Money You Need to Retire – Are They Wrong? (LO2) (LO3) (12:26)” will assist you in completing this assignment.
- Watching the video “Why I Wold Never Take Social Security at Age 65 by Medicare (LO2) (LO3) (15:04)” will assist you in completing this assignment.
Notes:
- Review the grading rubric to understand how the assignment will be graded.
- Follow the paper outline: (Note: You will answer the case questions 2 times, 1 time for Bob, and 1 time for you)
- Section 1: Introduction & Describe Process to Create the Model (1 – 2 pages)
- Section 2: Answer the case questions (1 – 2 pages)
- Section 3: Answer the case questions for yourself (2 -3 pages)
- Describe the process you used to analyze your personal situation.
- How many scenarios did you run; how long did it take you to feel comfortable with the numbers?
- Is the amount you are currently accumulating at your current savings rate adequate?
- How much should you be setting aside each year?
- How much will you have to live on when you retire?
- How long after retirement will you be able to live comfortably (like you are living now)?
- What risks do you face and how should your retirement planning take these risks into account?
- Thinking back to Week One and the experience with spreadsheet discussion do you feel more confident today in your ability to analyze data and build financial models using MX Excel? Why?
- After your experience in this class, do you see using MS Excel as an essential workplace skill? Why?
- What surprises did you experience while using the Retirement Planning Model to analyze your personal situation?
- What changes do you plan to make to your retirement planning strategy as a result of this project? Please explain?
- Discuss three things you learned while completing this project. Be specific.
- This assignment is due by the last day of the week.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
