BM151: Financial Services – Portfolio Project 2
Portfolio Project Overview
For most of the courses in the Business Fundamentals (BFN) Program, you will complete two tasks related to creating an online vegetarian catering business, which will constitute as part of your business plan. The purpose of the portfolio projects is to consider various aspects of small business activities, thereby demonstrating the application of knowledge, skills, and abilities acquired in each of your courses throughout the program.
Your Portfolio Project will consist of 2 parts and will culminate in a presentation to the class showing the progress made during your business development and planning. Remember – both parts of the Portfolio Project are related, with each part building on the next part.
Below is a list of topics that will be included in your portfolio from this course:
BM151 Financial Services
Taxes in Your Financial Plan
Selecting and Financing Property
Portfolio Project 2 Description:
Taking a loan is one of the most important business decisions that a businessperson should make sooner or later. When you have an opportunity to grow, and the lack of financial resources is a factor that does not allow you to do so, you should definitely consider attracting investments to let your business develop. Taking a loan could be a relatively cheap and beneficial way to gain extra resources.
Selecting and Financing Property
For your online vegetarian catering business, you rent a commercial kitchen, which requires monthly payments of $1,000. On the one hand, you do not have to think about depreciation, repairs, property taxes and utility bills. On the other hand, the kitchen is too small, and you are not satisfied with how it is equipped. Additionally, you have found yourself in conflict with the owner and are concerned that he can terminate your contract unexpectedly. With an increased number of orders, you have decided to consider a loan to extend your business.
You have found new premises that suit your needs. According to your calculations, buying the premises, creating your own kitchen and organizing a loan requires an investment of $200,000. You have done some research and found a loan with the following conditions:
the down payment constitutes 25% of the total amount of investment;
the annual interest rate is 4.5%;
the loan term is 15 years.
Prepare a Loan Amortization Schedule for the first year. Use the Excel template provided, and refer to the formulas of the article “Amortization Schedule” to calculate Total Monthly Payment, Principal Payment and Interest Payment for each of the months.
Prepare the Budgeted Income Statement that takes into account the loan.
Assume that the Budgeted Income Statement of your business is as follows:
|Option I – Without a loan|
|Budgeted Income Statement|
|For the Budget Year Ended December 31|
|Budgeted sales volume||
|Costs of goods sold||
|Marketing and administrative costs||
|Total budgeted costs||
|Budgeted operating profit||
|Federal and other income taxes (25%)||
|Budgeted profit after taxes||
NOTE: Currently, the Cost of Goods Sold includes $12,000 of yearly rental payments. Taking a loan will influence the Budgeted Income Statement:
the Cost of Goods Sold will reduce by the amount of rental payments;
the Cost of Goods Sold will increase by $4,000 that include depreciation, property taxes, utilities.
the Cost of Goods Sold will increase by the amount of Principal Payments;
the Interest Expense will reduce the Budgeted Operating profit.
Search on the Internet and find two different loans that could suit your needs (e.g., with a higher interest rate or shorter term). Prepare the Loan Amortization Schedule and Budgeted Income Statement for each of them (use the templates that you prepared to solve the problems above). Compare the four options and choose the one that results in the highest amount of Budgeted Profit After Taxes.
Your work must be posted to your Mahara portfolio webpage in Portfolio Part 2 in Moodle.
FOR INSTRUCTOR USE ONLY
Grading accepts a start value of 100. Points will be deducted for failure to fully complete or meet the stated requirements. Grading: 90-100 = Represents work of superior quality (A); 80-89 = Represents work of good to very good quality (B); 70-79 = Represents adequate command of class content (C); 69 and below = Represents work that shows a need for development or improvement (F); 0 = Represents plagiarized work (F).
BM151: Financial Services (BCP-BFN)
STUDENT LEARNING OUTCOMES
SLO-1. Identify factors that influence financial decisions.
SLO-2. Know what money management strategy is and how to develop it.
SLO-3. Identify strategies to improve money management in order to achieve personal and business financial goals.
SLO-5. Describe the benefits and issues associated with borrowing money from financial institutions.
SLO-11. Know how to prepare a loan amortization schedule and budgeted income statement that takes into account a loan.
SLO-12. Compare mortgage payment factors to choose the loan that helps achieve your financial goals.
Portfolio Project 2
YOUR SCORE: ________