Create a 5–10-minute video using Kaltura (or similar software) in which you will present a proposed financial plan for the upcoming year for a department in the City of Acme, along with supporting data visualizations and discussions of economic principles and drivers behind the financial plan.Data Visualization – Revisited You’re already familiar with data visualizations that inform your decision making. On your phone or laptop, you might look at a pie graph to check how much cloud storage you’re using versus how much is still available. Or you might look at line graphs online to see how the weather is forecast to change temperature over the next week. These visualizations are built on data that your computer or the weather service compiles into a specific dataset and then analyzes and organizes into the graph or chart you see so that it’s easy to understand.Visualizing data is all about making it easier to communicate the most important information. If you’re trying to find out the weather for your weekend plans, you need the right data, presented in an intelligent way to know if you should go out or stay home. When working with datasets, it’s imperative to keep in mind who the audience is, what information they might value the most, and what you want their takeaway to be.For example, your office might be upgrading a software program and the chief financial officer (CFO) may ask for a cost-benefit analysis of upgrading all at once versus a gradual rollout of the upgrade over a number of months. What is the most critical information is the CFO likely to want? How would be the best way to communicate this to them? When it comes to thinking critically about the data you analyze and using it to make decisions, your problem-solving skill can help you examine how a particular set of data relates in the most meaningful way for you and your audience. By using data to identify and frame the problems that concern a group, you can help them verify what matches and what contrasts in the dataset, identify clear trends, draw conclusions about basic relationships, and make predictions about patterns.Just like with your personal finances, if you are dealing with financial considerations in your career, you can use the same process to make visualizations about potential budget plans or even to recognize how much certain areas, resources, or even lack of investment could end up costing the company.SHOW LESSPresenting Professionally Throughout the course of your career, you are most likely going to be called upon to present on some topic relevant to your work. This could be a project, a department, or a proposal for something new at your workplace. No matter what the specifics are, it will be critical that you present yourself and your material professionally. This means making sure you are using appropriate language and terminology for the topic and the audience (it is important to speak to your audience at their level). It also means that the information and visuals you present should be well polished, well researched, well cited, and well organized. Haphazard visuals, incomplete data, plagiarized research, or disorganized presentations not only make it difficult for the audience to understand you, it also makes you appear unprofessional.So when presenting: Consider your audience. Consider the right information. Polish your words. Polish your visuals. Cite your sources. Stay organized. These are basic points, but if followed, these can help you act professionally and deliver a quality presentation.For this assessment, you will be drawing upon your problem-solving, agility, and technology skills to design a budget that works and communicate in an effective way.Competency Map CHECK YOUR PROGRESSUse this online tool to track your performance and progress through your course. Toggle DrawerResources Professional Budgets Professional budgeting can involve a similar process to personal budgeting. Income and expenditures need to be accounted for in budgets for departments and businesses. Current and projected economic trends should be taken into account when making decisions about resources. The main difference is that budgets in professional settings involve larger sums of money and can impact many for individuals (whose jobs depend on good budgeting). The more you progress upward in your careers, the more likely you will have some involvement with a budget in your professional setting. The following resources will help you build your understanding of the different considerations that are need for budgets in professional settings, as well as prepare you for the assessment. Hao, D. (2018, February 27). A new leader's guide to efficient budget management [Blog post]. Retrieved from https://blog.procurify.com/2018/02/27/create-manag... McCarthy, D. (2019). Budget management tips for new managers. Retrieved from https://www.thebalancecareers.com/budgeting-essent... Chang, J. (2019, January 14). How to build a successful budget plan that works [Blog post]. Retrieved from https://blog.procurify.com/2019/01/14/how-to-build... St. Laurent, S. (n.d.). 5 steps to presenting an exceptional departmental budget. Retrieved from https://dryrun.com/5-steps-to-presenting-an-except... Ibrahim, M. (2019). Designing zero-based budgeting for public organizations [PDF]. Problems and Perspectives in Management, 17(2), 323–333. Weber, J., & Linder, S. (2005). Budgeting, better budgeting, or beyond budgeting. Cost Management, 19(2), 20–28. Capella Stories: Fashion by the Numbers. When you think about the skills needed to stand out in the world of fashion, technology might not come to the front of your mind. In this video, you’ll meet fashion designer Deidre Jefferies and discover how her technology skill helped her fashion business thrive. SHOW LESSEconomic Concepts – Revisited The following resources present a somewhat more in-depth look at two economic concepts that can have a big impact on budgeting decisions and organizations.  Opportunity Cost. Agarwal, P. (2020). Opportunity cost. Retrieved from https://www.intelligenteconomist.com/opportunity-c... Agarwal, P. (2018). Supply and demand. Retrieved from https://www.intelligenteconomist.com/supply-and-de... Kaltura As part of your submission for this assessment, you are required to create a video presentation. If you are using Kaltura for recording the video, the following resource could be helpful: Using Kaltura. Assessment Instructions Overview In our careers, as our responsibilities grow and we take leadership of a department a natural request is for a budget proposal each fiscal year. Budgets provide parameters for us to achieve our goals. Spend too much and you will find yourself in a deficit. Spend too little and you could have a surplus, which may not be a good sign if an organization's goals have not been met. Using technology can help you stay organized throughout your analysis, as well as help visualize financial data. Displaying the data visually will allow you to observe general trends in your department finances and to communicate about them effectively to appropriate stakeholders.For this assessment, you will be using Excel as your technology tool to analyze department data and display that data visually. There are many other technologies available for professional use that can be used for this type of analysis. The approach to learning and working with Excel software in this course is one you can apply to other technology tools in your life and career.Your goal for this assessment is to build your confidence and practice in the technology skill by conducting a department financial analysis using a technology tool. You will use Excel to organize a quarterly and an annual budget, visualize this financial data using charts and graphs, and discuss the results of your financial analysis, including progress toward your selected department financial goal.Preparation Read the scenario below to understand the context for this assessment. Review the Assessment 4 Template [XLSX]. This completed template will be one of your deliverables for this assessment.Scenario You are the associate administrator of a large department in the City of Acme with an operating budget of 1.8 million dollars. Your boss, the administrator, has asked you to create a presentation with graphs that demonstrate how you should allocate next fiscal year’s budget.Instructions Using what you have learned about budgeting, Excel, and creating data visualizations, complete the Assessment 4 Template [XLSX]. Then create a 5–10-minute video in which you present your proposed budget to the department and leadership.For this assessment, complete the following steps: Step 1: Use the Assessment 4 Template [XLSX] to review the current annual budget. After your review the current budget, create a new Proposed Budget.  Scoring guide criteria: Create a Proposed Budget based on a professional financial analysis of a Year-to-Date Budget. You have the original budget, the 9-month budget (or Year-to-Date at 9 months), and the empty budget spreadsheet for the next year. Please read the comments (notes) in the cells (indicated by red triangles in the upper right corner of the cells). Based on this data, how will you propose the budget be updated in the following fiscal year? Consider the following before filling in the cells for the next fiscal year: It is rumored there will be a 3-percent increase in cost of living. Consider budgeting this increase for personnel cost. There were many outdated computers that completely crashed in the current budget. This is why there is an increase at the 9-month mark. It is up to you if you plan for more issues next year as only two-third of the computers were replaced in the current year. You will not need as many vehicles in the next year. If each vehicle is valued at about 36,475 dollars, consider a conservative amount to budget for next year. If you do not add more vehicles, consider a substantial increase to Vehicle Maintenance in the new year for repairs. Step 2: Create graphs of the Current Year Budget, the Year-to-Date Budget, and the Proposed Budget. Scoring guide criteria: Create appropriate graphs to illustrate the findings of a professional financial analysis. You should use Excel to create these graphs in the Assessment 4 Template [XLSX]. Remember, you may wish to display these graphs during your video. So, it is worth considering the audience for your video and how the graphs will appear during the presentation. Step 3: Make a video presentation using Kaltura (or another video recording method with which you are familiar) in which you review your analysis and Proposed Budget. At the end, briefly explain why you chose the graphs you did. Scoring guide criteria: Explain the results of a professional financial analysis, including overall progress and why the Proposed Budget is the best possible forecast for the new year. Make your recommendation for the Proposed Budget with your logic for the proposed increase or decrease in the new budget. Discuss whether your final budget is conservative (meaning in the worst possible scenario it would still work) or aggressive (meaning that all budget metrics needs to be hit for you not to be in a deficit next year). Scoring guide criteria: Explain how selected graphs are the best choice to communicate financial information. Discuss the graphs that you chose to present the data from the three budgets in the Assessment 4 Template. How do they help the audience better understand the presented financial data? How are they better than other types of graphs you considered? Scoring guide criteria: Address the appropriate audience, using familiar, discipline-specific language and terminology. Are you speaking to the audience in the scenario (that is, department members and leadership) in your presentation? Is the language you are using appropriate for the scenario and your role as an assistant administrator? Are you using appropriate economic and finance terminology? Remember, you need to submit both completed Assessment 4 Template and your 5–10-minute video presentation for this assessment.Additional Requirements Your assessment should also follow the following requirements: Communication: Communicate in a manner that is scholarly, professional, respectful, and consistent with expectations for professional practice in education. Original work and critical thinking are required regarding your assessment and scholarly writing. Your writing must be free of errors that detract from the overall message. Video presentation: 5–10 minutes.

ALL WORKS MUST BE SHOWN AND DONE ON EXCEL.1. The Beakman Corp. has $1,000 PAR bond at 5% interest. The bonds will mature in 10 years. Compute the current price of the bond if the present yield to maturity is 8%. Is this bond trading at par, discount or premium (15 POINTS)?2. Suppose a German company issues a bond with a par value of E1,000 25 years to maturity and a coupon rate of 6% paid annually. If the yield to maturity is 5%, what is the current price of the bond? Is this bond trading at par, discount or premium (15 POINTS)?3. Go to Morningstar.com and look up the mutual Fund Fidelity ContraFund (FCNTX) and American Funds Growth Fund of America (AGTHX). Determine what the rate of return was for the years 2015, 2016, 2017, 2018, and 2019 for both funds. Determine the average rate of return for those past 5 years for both funds. Then determine the 5-year variance and standard deviation for both mutual funds (You can use excel or written formulas). Based on your findings, explain which mutual fund you would invest in and why (15 Points).4. Honda Motor Corp. has a beta of 1.15, the expected 5 year return on the market (S&P 500) is 11.58%, and the risk free investment (30 year US Treasury) is 2.25%. What must my expected return be for Honda (10 Points)? 5. Stock in Walmart is selling for $88 per share. You believe there is little possibility the stock will sell for less than $80 per share within one year (15 Points).a. What is the intrinsic value of a call option with a $83 exercise price?b. What is the intrinsic value of a call option with a $78 exercise price? c. What is the intrinsic value of a put option with a $75 exercise price?6. Compare and contrast the three forms of market efficiency. Which theory do you believe to be the most accurate and why (15 Points)?7. According to Andre Shleifer, there are three conditions that will lead to market efficiency – Rationality, Independent Deviations from Rationality, and Arbitrage. However, according to behavioral finance theories, the above conditions are not likely to hold in reality. Explain from a behavioral finance perspective, why the above three conditions are not likely to hold up in real world scenarios (15 Points)

In economics hypothesis can be converted into theories and models. Do you agree, If yes, why? and if not, why not?Give examples to justify your arguments./point of view.