Week Three Financial Exercises
Part 1
Using the table below, describe the types of budgets. In your description, include:
The objective of the budget
How the budget assists an organization in managing its financial activities
What types of data need to be included in that specific budget
Type of Budget
Cash Flow
Operating
Sales
Static
Financial
Description
Week Three Financial Exercises
Part 2
Complete the following problems using the following ratios:
Sales level at which operating income is zero
o If sales above breakeven, then profit
o If sales below breakeven, then loss
o Fixed expenses = total contribution margin
Total sales = total expenses
Break Even Point: Unit Sold = Fixed expenses + Operating Income / Contribution Margin per unit
Break Even Point: Sales $ = Fixed expenses + Operating Income / Contribution Margin Ratio
(1)
Calculate the break even number of units if the fixed expenses are $7,000 and the contribution margin is $14 per unit.
Answer:
(2)
Calculate the break even sales dollars if the fixed expenses are $7,000 and the contribution ratio is 40%.
Answer:
(3)
Calculate the break even number of units with a target profit of $120,000 if the fixed expenses are $15,000 and the contribution margin is $60 per unit.
Answer:
Week Three Financial Exercises
Part 3
Complete the following problems:
(1)
(2)
How much will you have saved after 6 years by contributing $1,200 at the end of each year if you expect to earn 11% on the investment?
Answer:
A business owner plans to deposit his annual profits in an investment account earning a 9% annual return. If the owner starts with their first deposit
today for $22,000 and expects to make the same profit for the next 7 years, how much will be saved for retirement at that point?
Answer:
(3)
(4)
An investor plans to invest $500 a year and expects to get a 10.5% return. If the investor makes these contributions at the end of the next 20 years,
what is the present value of this investment today?
Answer:
What is the present value (PV) of a 12-year lease arrangement with an interest rate of 7.5 percent that requires annual payments of $4,250 per year
with the first payment being due now?
Answer:
(5)
A recent college graduate hopes to have $200,000 saved in their retirement account 25 years from now by contributing $150 per month in a 401(k)
plan. The goal is to earn 10% annually on the monthly contribution. Will they have the $200,000 at the end of the 25 years?
Answer:
