Assignment Prompt & Instructions
**files (6)**
– ## cf_assessment_3_word_template.docx
– ## cf_assessment_2_word_template.docx
– ## cf_assessment_4_template.xlsx
– cf_asst_3_excel_template.xlsx
– cf_assessment_1_template.docx
– cf_asst_2_excel_template.xlsx
**## cf_assessment_3_word_template.docx**
**ECO-FP1100**
**ECO-FP1100**
**Assessment 3 Word Template**
While writing responses to the prompts below, you may need to refer back to the budgets and graphs you created in the Assessment 3 Excel Template. Make sure you have completed your budget before completing this portion of the assessment.
### Questions
1. Explain why you chose the particular graphs or charts that you did. How do the graphs or charts you created help someone understand the financial information from your personal financial analysis? Why are they better than other graphs you considered creating?
[Write your response to question 1 here.]
2. Explain the results of your financial analysis, including overall progress toward savings goals, potential changes in your budget that can be made in the future, and possible economic or life impacts that may affect your budget in the coming year.
[Write your response to question 2 here.]
3. Project how your financial analysis will look in one year. Take into account economic concepts and trends.
a. What economic concepts might be relevant (income growth, inflation, consumer prices, et cetera)?
b. What economic trends might you want try to account for when making your projection?
c. How could you try to plan for unexpected expenses when making your projection?
[Write your response to question 3 here.]
1
2
## image1.png
**## cf_assessment_2_word_template.docx**
**ECO-FP1100**
**ECO-FP1100**
**Assessment 2 Word Template**
While writing responses to the prompts below, you may need to refer back to the budget you created in the Assessment 2 Excel Template. Make sure you have completed your budget before completing this portion of the assessment.
### Questions
1. Identify the savings goal and the time frame you determined for reaching your goal. Why is the time frame you identified realistic? How did you arrive at this?
Think about how long you expect it to sell or rent your current home, the price of purchasing or renting in your New City, et cetera. Use research from the course reading or outside sources to support your time frame.
[Write your response to question 1 here.]
2. Explain why you chose the housing option you did and how it will help you achieve your selected financial goal.
a. What considerations, if any, did you give to the following when selecting your housing option?
i. Time frame for savings goal.
ii. Familial situation.
iii. Quality of life.
iv. Trade-off decisions.
v. Other considerations.
[Write your response to question 2 here.]
3. Explain your choices for non-rent expenditures and how they will help achieve your savings goal within the time frame.
a. How did you make the choices you did regarding non-housing expenditures?
b. How do your expenditures align with the financial goal you selected?
[Write your response to question 3 here.]
4. Reflect on the productivity strategies you used to break down your financial plan into smaller steps to help you stay organized and productive.
a. How closely did you follow the plan you thought through earlier in the assessment instructions?
b. How did a step-by-step and organized approach help you to adjust your financial priorities and financial plan?
c. How did the approach you use draw upon productivity strategies that you had previously learned?
[Write your response to question 4 here.]
5. Reflect on what your financial analysis might reasonably look like in a year, taking into account income growth and inflation of consumer prices.
a. What assumptions can you make about your income from your new position in a year’s time?
i. What other sources of income might you have?
b. How is inflation likely to impact your non-housing expenditures?
c. How will your financial plan look depending on the situation with your new housing and your previous home?
d. What other economic concepts will you take into account? How might they impact your financial analysis a year from now?
1
2
## image1.png
**## cf_assessment_4_template.xlsx**
## Assessment 4
| | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — |
| ECO-FP1100: Assessment 4 | | | Enter data | | Note: Remember to create graphs for each of the three budgets in this template. |
| | | | Populates Automatically |
| Current Year Budget | $ 1,800,000.00 | | Year-to-Date Budget | $ 1,800,000.00 | | Proposed Budget | user: user:<br>You will enter this number after you have populated your budget for next year. You will be entering the number that appears in the blue cell: H23 | | Proposed Budget Rationale Notes (Note how you built in the considerations from the assignment instructions here: Cost of Living increase; Planning for issues like outdated equipment; Vehicle considerations; Any other specific decisions you made.): |
| | | | 9 months of info (3 Qtrs) |
| Personnel | | | Personnel | | | Personnel |
| Salaried Employees 8 FTE | $ 600,000.00 | | Salaried Employees 8 FTE | $ 450,000.00 | | Salaried Employees 8 FTE |
| Non Salaried Employees 13 FTE | $ 450,000.00 | | Non Salaried Employees 13 FTE | $ 298,500.00<br> <br>user: user:<br>Some turnover in this area created what appears to be a surplass but you should budget to meet or exceed original budget | | Non Salaried Employees 13 FTE |
| Benefits | $ 315,000.00 | | Benefits | $ 224,550.00 | | Benefits |
| Operating Funds | | | Operating Funds | | | Operating Funds |
| Office Supplies | $ 30,000.00 | | Office Supplies | $ 30,000.00 | | Office Supplies |
| Utilities | $ 45,000.00 | | Utilities | $ 34,762.50<br> <br>user: user:<br>You were notified of a 3% increase at the start of the new fiscal year and you are over on your projection here now | | Utilities |
| Vehicle Maintenance | $ 900.00 | | Vehicle Maintenance | $ 475.00 | | Vehicle Maintenance |
| Liability Insurance | $ 65,000.00 | | Liability Insurance | $ 48,749.99 | | Liability Insurance |
| Contracts | $ 38,000.00 | | Contracts | $ 24,750.00 | | Contracts |
| Capital | | | Capital | | | Capital |
| Computers | $ 35,000.00 | | Computers | $ 41,950.00 | | Computers |
| Vehicles | $ 145,900.00 | | Vehicles | $ 124,973.00 | | Vehicles |
| Infrastructure | $ 65,000.00 | | Infrastructure | $ 73,000.00 | | Infrastructure |
| Miscellaneous | | | Miscellaneous | | | Miscellaneous |
| Petty cash | $ 200.00 | | Petty cash | $ 100.00 | | Petty cash |
| Other expenses | $ 10,000.00 | | Other expenses | $ 3,756.00 | | Other expenses |
| | $ 1,800,000.00 | | | $ 1,355,566.49 | | Subtotal (Should Match H4) | $ – 0 |
| Note: Remember to create graphs for each of the three budgets in this template. |
**cf_asst_3_excel_template.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-asst-3-excel-template-xlsx-10497229)
**cf_assessment_1_template.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-assessment-1-template-docx-10497227)
**cf_asst_2_excel_template.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-asst-2-excel-template-xlsx-10497237)
**cf_asst_2_excel_template.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-asst-2-excel-template-xlsx-10497237)
**## cf_assessment_3_word_template.docx**
**ECO-FP1100**
**ECO-FP1100**
**Assessment 3 Word Template**
While writing responses to the prompts below, you may need to refer back to the budgets and graphs you created in the Assessment 3 Excel Template. Make sure you have completed your budget before completing this portion of the assessment.
### Questions
1. Explain why you chose the particular graphs or charts that you did. How do the graphs or charts you created help someone understand the financial information from your personal financial analysis? Why are they better than other graphs you considered creating?
[Write your response to question 1 here.]
2. Explain the results of your financial analysis, including overall progress toward savings goals, potential changes in your budget that can be made in the future, and possible economic or life impacts that may affect your budget in the coming year.
[Write your response to question 2 here.]
3. Project how your financial analysis will look in one year. Take into account economic concepts and trends.
a. What economic concepts might be relevant (income growth, inflation, consumer prices, et cetera)?
b. What economic trends might you want try to account for when making your projection?
c. How could you try to plan for unexpected expenses when making your projection?
[Write your response to question 3 here.]
1
2
## image1.png
**## cf_assessment_2_word_template.docx**
**ECO-FP1100**
**ECO-FP1100**
**Assessment 2 Word Template**
While writing responses to the prompts below, you may need to refer back to the budget you created in the Assessment 2 Excel Template. Make sure you have completed your budget before completing this portion of the assessment.
### Questions
1. Identify the savings goal and the time frame you determined for reaching your goal. Why is the time frame you identified realistic? How did you arrive at this?
Think about how long you expect it to sell or rent your current home, the price of purchasing or renting in your New City, et cetera. Use research from the course reading or outside sources to support your time frame.
[Write your response to question 1 here.]
2. Explain why you chose the housing option you did and how it will help you achieve your selected financial goal.
a. What considerations, if any, did you give to the following when selecting your housing option?
i. Time frame for savings goal.
ii. Familial situation.
iii. Quality of life.
iv. Trade-off decisions.
v. Other considerations.
[Write your response to question 2 here.]
3. Explain your choices for non-rent expenditures and how they will help achieve your savings goal within the time frame.
a. How did you make the choices you did regarding non-housing expenditures?
b. How do your expenditures align with the financial goal you selected?
[Write your response to question 3 here.]
4. Reflect on the productivity strategies you used to break down your financial plan into smaller steps to help you stay organized and productive.
a. How closely did you follow the plan you thought through earlier in the assessment instructions?
b. How did a step-by-step and organized approach help you to adjust your financial priorities and financial plan?
c. How did the approach you use draw upon productivity strategies that you had previously learned?
[Write your response to question 4 here.]
5. Reflect on what your financial analysis might reasonably look like in a year, taking into account income growth and inflation of consumer prices.
a. What assumptions can you make about your income from your new position in a year’s time?
i. What other sources of income might you have?
b. How is inflation likely to impact your non-housing expenditures?
c. How will your financial plan look depending on the situation with your new housing and your previous home?
d. What other economic concepts will you take into account? How might they impact your financial analysis a year from now?
1
2
## image1.png
**## cf_assessment_4_template.xlsx**
## Assessment 4
| | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — |
| ECO-FP1100: Assessment 4 | | | Enter data | | Note: Remember to create graphs for each of the three budgets in this template. |
| | | | Populates Automatically |
| Current Year Budget | $ 1,800,000.00 | | Year-to-Date Budget | $ 1,800,000.00 | | Proposed Budget | user: user:<br>You will enter this number after you have populated your budget for next year. You will be entering the number that appears in the blue cell: H23 | | Proposed Budget Rationale Notes (Note how you built in the considerations from the assignment instructions here: Cost of Living increase; Planning for issues like outdated equipment; Vehicle considerations; Any other specific decisions you made.): |
| | | | 9 months of info (3 Qtrs) |
| Personnel | | | Personnel | | | Personnel |
| Salaried Employees 8 FTE | $ 600,000.00 | | Salaried Employees 8 FTE | $ 450,000.00 | | Salaried Employees 8 FTE |
| Non Salaried Employees 13 FTE | $ 450,000.00 | | Non Salaried Employees 13 FTE | $ 298,500.00<br> <br>user: user:<br>Some turnover in this area created what appears to be a surplass but you should budget to meet or exceed original budget | | Non Salaried Employees 13 FTE |
| Benefits | $ 315,000.00 | | Benefits | $ 224,550.00 | | Benefits |
| Operating Funds | | | Operating Funds | | | Operating Funds |
| Office Supplies | $ 30,000.00 | | Office Supplies | $ 30,000.00 | | Office Supplies |
| Utilities | $ 45,000.00 | | Utilities | $ 34,762.50<br> <br>user: user:<br>You were notified of a 3% increase at the start of the new fiscal year and you are over on your projection here now | | Utilities |
| Vehicle Maintenance | $ 900.00 | | Vehicle Maintenance | $ 475.00 | | Vehicle Maintenance |
| Liability Insurance | $ 65,000.00 | | Liability Insurance | $ 48,749.99 | | Liability Insurance |
| Contracts | $ 38,000.00 | | Contracts | $ 24,750.00 | | Contracts |
| Capital | | | Capital | | | Capital |
| Computers | $ 35,000.00 | | Computers | $ 41,950.00 | | Computers |
| Vehicles | $ 145,900.00 | | Vehicles | $ 124,973.00 | | Vehicles |
| Infrastructure | $ 65,000.00 | | Infrastructure | $ 73,000.00 | | Infrastructure |
| Miscellaneous | | | Miscellaneous | | | Miscellaneous |
| Petty cash | $ 200.00 | | Petty cash | $ 100.00 | | Petty cash |
| Other expenses | $ 10,000.00 | | Other expenses | $ 3,756.00 | | Other expenses |
| | $ 1,800,000.00 | | | $ 1,355,566.49 | | Subtotal (Should Match H4) | $ – 0 |
| Note: Remember to create graphs for each of the three budgets in this template. |
**cf_asst_3_excel_template.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-asst-3-excel-template-xlsx-10497229)
**cf_assessment_1_template.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-assessment-1-template-docx-10497227)
**cf_asst_2_excel_template.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-asst-2-excel-template-xlsx-10497237)
**## cf_assessment_3_word_template.docx**
**ECO-FP1100**
**ECO-FP1100**
**Assessment 3 Word Template**
While writing responses to the prompts below, you may need to refer back to the budgets and graphs you created in the Assessment 3 Excel Template. Make sure you have completed your budget before completing this portion of the assessment.
### Questions
1. Explain why you chose the particular graphs or charts that you did. How do the graphs or charts you created help someone understand the financial information from your personal financial analysis? Why are they better than other graphs you considered creating?
[Write your response to question 1 here.]
2. Explain the results of your financial analysis, including overall progress toward savings goals, potential changes in your budget that can be made in the future, and possible economic or life impacts that may affect your budget in the coming year.
[Write your response to question 2 here.]
3. Project how your financial analysis will look in one year. Take into account economic concepts and trends.
a. What economic concepts might be relevant (income growth, inflation, consumer prices, et cetera)?
b. What economic trends might you want try to account for when making your projection?
c. How could you try to plan for unexpected expenses when making your projection?
[Write your response to question 3 here.]
1
2
## image1.png
**## cf_assessment_2_word_template.docx**
**ECO-FP1100**
**ECO-FP1100**
**Assessment 2 Word Template**
While writing responses to the prompts below, you may need to refer back to the budget you created in the Assessment 2 Excel Template. Make sure you have completed your budget before completing this portion of the assessment.
### Questions
1. Identify the savings goal and the time frame you determined for reaching your goal. Why is the time frame you identified realistic? How did you arrive at this?
Think about how long you expect it to sell or rent your current home, the price of purchasing or renting in your New City, et cetera. Use research from the course reading or outside sources to support your time frame.
[Write your response to question 1 here.]
2. Explain why you chose the housing option you did and how it will help you achieve your selected financial goal.
a. What considerations, if any, did you give to the following when selecting your housing option?
i. Time frame for savings goal.
ii. Familial situation.
iii. Quality of life.
iv. Trade-off decisions.
v. Other considerations.
[Write your response to question 2 here.]
3. Explain your choices for non-rent expenditures and how they will help achieve your savings goal within the time frame.
a. How did you make the choices you did regarding non-housing expenditures?
b. How do your expenditures align with the financial goal you selected?
[Write your response to question 3 here.]
4. Reflect on the productivity strategies you used to break down your financial plan into smaller steps to help you stay organized and productive.
a. How closely did you follow the plan you thought through earlier in the assessment instructions?
b. How did a step-by-step and organized approach help you to adjust your financial priorities and financial plan?
c. How did the approach you use draw upon productivity strategies that you had previously learned?
[Write your response to question 4 here.]
5. Reflect on what your financial analysis might reasonably look like in a year, taking into account income growth and inflation of consumer prices.
a. What assumptions can you make about your income from your new position in a year’s time?
i. What other sources of income might you have?
b. How is inflation likely to impact your non-housing expenditures?
c. How will your financial plan look depending on the situation with your new housing and your previous home?
d. What other economic concepts will you take into account? How might they impact your financial analysis a year from now?
1
2
## image1.png
**## cf_assessment_4_template.xlsx**
## Assessment 4
| | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — |
| ECO-FP1100: Assessment 4 | | | Enter data | | Note: Remember to create graphs for each of the three budgets in this template. |
| | | | Populates Automatically |
| Current Year Budget | $ 1,800,000.00 | | Year-to-Date Budget | $ 1,800,000.00 | | Proposed Budget | user: user:<br>You will enter this number after you have populated your budget for next year. You will be entering the number that appears in the blue cell: H23 | | Proposed Budget Rationale Notes (Note how you built in the considerations from the assignment instructions here: Cost of Living increase; Planning for issues like outdated equipment; Vehicle considerations; Any other specific decisions you made.): |
| | | | 9 months of info (3 Qtrs) |
| Personnel | | | Personnel | | | Personnel |
| Salaried Employees 8 FTE | $ 600,000.00 | | Salaried Employees 8 FTE | $ 450,000.00 | | Salaried Employees 8 FTE |
| Non Salaried Employees 13 FTE | $ 450,000.00 | | Non Salaried Employees 13 FTE | $ 298,500.00<br> <br>user: user:<br>Some turnover in this area created what appears to be a surplass but you should budget to meet or exceed original budget | | Non Salaried Employees 13 FTE |
| Benefits | $ 315,000.00 | | Benefits | $ 224,550.00 | | Benefits |
| Operating Funds | | | Operating Funds | | | Operating Funds |
| Office Supplies | $ 30,000.00 | | Office Supplies | $ 30,000.00 | | Office Supplies |
| Utilities | $ 45,000.00 | | Utilities | $ 34,762.50<br> <br>user: user:<br>You were notified of a 3% increase at the start of the new fiscal year and you are over on your projection here now | | Utilities |
| Vehicle Maintenance | $ 900.00 | | Vehicle Maintenance | $ 475.00 | | Vehicle Maintenance |
| Liability Insurance | $ 65,000.00 | | Liability Insurance | $ 48,749.99 | | Liability Insurance |
| Contracts | $ 38,000.00 | | Contracts | $ 24,750.00 | | Contracts |
| Capital | | | Capital | | | Capital |
| Computers | $ 35,000.00 | | Computers | $ 41,950.00 | | Computers |
| Vehicles | $ 145,900.00 | | Vehicles | $ 124,973.00 | | Vehicles |
| Infrastructure | $ 65,000.00 | | Infrastructure | $ 73,000.00 | | Infrastructure |
| Miscellaneous | | | Miscellaneous | | | Miscellaneous |
| Petty cash | $ 200.00 | | Petty cash | $ 100.00 | | Petty cash |
| Other expenses | $ 10,000.00 | | Other expenses | $ 3,756.00 | | Other expenses |
| | $ 1,800,000.00 | | | $ 1,355,566.49 | | Subtotal (Should Match H4) | $ – 0 |
| Note: Remember to create graphs for each of the three budgets in this template. |
**cf_asst_3_excel_template.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-asst-3-excel-template-xlsx-10497229)
**cf_assessment_1_template.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-assessment-1-template-docx-10497227)
**cf_asst_2_excel_template.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cf-asst-2-excel-template-xlsx-10497237)