Economics Homework Help

Video Presentation Activity

Objective

In this learning activity, you will create a short video of one of your(solved)Excel models. You will use zoom to record an (up to 6-minute)video explaining the basics of your model (what it does and how and why it is useful to a user). Through this learning activity, you will engage in the following.

1.To practice and demonstrate effective communication skills by explaining the functionality of an Excel model, using current technology tools (Zoom). The ideal is to “sell” your model to your audience.

2.To demonstrate proper knowledge of building and using an Excel model and how it can be useful(i.e., what business problem does it solve, “what-if” functionality/analysis your model has). The more complex and interesting the model, the better. Simple models are not impressive.

The model you present should come from one of the homework problems you solved, NOT from the examples in the textbook. Presentations with more complex models will earn a higher grade. Presentations with simpler models will earn a lower grade. Think of your audience as your future boss, or a future client that is interested in using excel to improve their business operation or solve a business problem.

Points to think about:

•Best practice is to show your face while you record and present the audience can “connect” with you. Impress your audience with your presentation skills and with an interesting enough excel model that displays your superior Excel skills (not just basic skills).

•Practice going over your model several times, think about how you would want someone to show the model to you for maximum comprehension. Explain the benefits.

•Remember, your task is to show or“walk” your audience through your model, so they see the benefit of using it in their respective workplace(make assumptions as to the workplace). Emphasize explaining the “why you should use this model” that you are showing. Demonstrate the power of the “what-if” functionality your model provides the audience.

•Keep in mind you could share this video with toa potential future employer to display your superior knowledge of Excel and your ability to present information virtually. The more professional and interesting presentation, the better odds at landing the job.

problem 1 – Durango Mountain Bike Tours, parts A-D :”Durango Mountain Bike Tours’ ending cash balance as of December 31, 2020 was $10,000. Its expected cash collections and payments for the next six months are given in the following table.MonthCollectionsPaymentsJanuary$18,563$21,825February30,88135,100March51,07548,600April81,84468,344May109,68890,113June141,750107,100

a.Calculate the firm’s expected ending cash balance for each month.

b.Assuming that the firm must maintain an ending cash balance of at least $12,000, how much must they borrow during each month?

c.If the firm must pay 5% annual interest on its short-term borrowing, what are the ending cash balances for each month?

d.What are the ending cash balances if the firm uses any cash in excess of the minimum to pay off its short-term borrowing in each month?”