Instructions:
Fill in all the YELLOW cells
Sales Revenue is collected:
30% in the month of the sale;
35% in the month after the sale;
35% in the third month
Raw Material Purchases equal 50% of the previous month's revenue.
Final Month-End Cash Balance must always be minimum $5,000.
You may need to borrow to maintain minimum cash balance.
Interest is paid in any month if money was owed at the end of the previous month.
Economic factors affect financial planning
A. Consumer prices
1. Changes in the value of the dollar
2. Consumers confident
B. Inflation
1. Rising prices for goods and services and lower buying power of the dollar (Practical Money Skills, 2015).
2. Increases in business expenses
C. Interest Rates
1. The cost of borrowing money.
a) Lower interest rates encourage consumer spending
b) Higher rates encourage saving and less borrowing.
D. Unemployment Rate
1. The number of unemployed people who are willing to work, which affects consumer spending and job opportunities.
2. Technological advances, corporate values, seasonal fluctuation can affect unemployment rate.
Attachment:- Assignment.rar