Students will construct a set of forecasted financial statements and calculate a set of financial ratios...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Students will construct a set of forecasted financial statements and calculate a set of financial ratios for a start-up business. Note: Please read the documents related to forecasting financial statements under Documents & Resources in Week 4. Additionally, search online for information regarding forecasting financial statements. [Don't skip this step! It will provide background context and insight into what you'll be doing for this assignment.] You will notice that there are many methods to use to forecast financials. Some are quantitative while others are qualitative. Often, a mix of the two are used. There is no one exact way to perform forecasting. For the purpose of this assignment, you will be relying on the directions given under Forecasting Assumptions' to complete the Excel workbook. Case Overview Janelle Higgins has decided to start her own event planning business (JH Events) in the upcoming year. She believes that she has an innovative business model and is seeking a business loan. Therefore, Janelle is in the process of putting together a business plan. As part of her business plan, Janelle must include forecasted financial statements for the first 5 years. The forecasted financial statements to be included are: Income Statement, Balance Sheet, and Statement of Cash Flows. Janelle must also include a set of calculated ratios along with an overall assessment on the projected health of the company. Forecasting Assumptions • • First year sales are projected to be $150,000 and grow 3% for the next two years and 5% in year 4 and 5. Cost of sales are projected to be 45% of revenue in the first year and is expected to grow at the same rate as sales. • Advertising expenses are projected to be 4% of each year's projected revenue. Janelle will need to rent equipment for the events she puts on. She has an agreement with a rental company for a flat rate of $500 per month and is sufficient to cover all of her estimated events. Starting in Year 3, she expects to be able to handle more events and the rental rate will increase to $750 per month. • Janelle plans to start off by hiring 2 people to work the events with her. Each person will be paid $100 per event and is expected to work 4 events per month. After Year 3, Janelle plans to hire 2 additional people. (At this point, each person will be paid $100 per event and is expected to work 3 events per month). Office rent is estimated to be a flat rate of $1,200 per month. Utilities for the rented office space are estimated to be $300 per month. The office space Janelle plans to rent is unfurnished. She plans to purchase $15,000 worth of furniture and fixtures at the beginning of Year 1. The furniture and fixtures will have a useful life of 15 years. Janelle will also need to buy some computers and other • office equipment that she will purchase for $10,000 also at the beginning of Year 1. The office equipment will have a useful life of 5 years. Both the furniture and fixtures as well as the equipment will be depreciated on a straight-line basis (Assume zero salvage value for calculations). HINT: Fixed Assets - Accumulated Depreciation = 'Net' Fixed Assets Janelle is asking for a 3-year bank loan for $60,000 to be funded on Day1 of Year 1. The estimated interest on the loan is 3% (assume simple interest). She will pay the loan back in $20,000 installments starting in Year 2. Interest is due at the end of each year and paid in January of the following year. (Assume interest is paid on the principal balance still outstanding at year-end). The tax rate for JH Events is 35%. Taxes for the year just ended are payed in the first quarter of the following year. Janelle will invest $30,000 of her own money and from family and friends, before the beginning of the year, to start the business. This $30,000 investment of capital is also the beginning bank balance of Year 1. Schedule of expected year-end balances of selected accounts: Year 1 Year 2 Year 3 Year 4 Year 5 Accounts 10,000 12,000 8,000 6,000 10,000 Receivable Accounts 2,000 4,000 5,000 6,000 9,000 Payable Customer 1,500 2,000 3,000 4,000 5,000 Deposits • At the end of Year 2, Janelle will purchase an insurance policy to help cover the business. The policy has a term of 3 years and coverage starts at the beginning of Year 3. The policy costs $12,000. • During Year 3, Janelle plans to personally invest $10,000 of additional capital into the business. Chart of Accounts All accounts listed here should be included in your financial statements. • " Cash Accounts Receivable Prepaid Insurance ■ Furnitures & Fixtures Equipment " ■ Accounts Payable " Customer Deposits • Interest Payable Taxes Payable ■ Bank Loan Capital Retained Earnings Revenue Cost of Sales Advertising Equipment Rental Wages Office Rent Utilities Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells – do not alter these formulas. - ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotala on the 'Cash Flow State sier estac " " Equipment Rental Wages Office Rent " Utilities ■ " ■ Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance ☐ You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells - do not alter these formulas. ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotals on the 'Cash Flow Statement' tab for each major category) ☐ On each tab there is an area to keep track of the various assumptions. The column labeled 'Assumptions' is to make note of any numbers, percentages, etc. relevant to that line item. The column labeled ‘Assumption Explanations' is to help keep track of the 'Forecasting Assumptions' from above. (You can copy and paste the assumptions onto the relevant line item). On the ‘Ratios' tab there is an area to layout the formulas and show your work. ☐ There is a grading area on each tab that is being calculated as you input information. Please use this area to see where any mistakes are being made. ☐ You must upload your file to Blackboard under Week 5 Assignments (Include your name as part of the file name). Go to the Assignment, scroll down to "Attach Local File" and click Browse to select YOUR file, then hit SUBMIT. Revenue Cost of Sales Gross Margin Operating Expenses Advertising Equipment Rental Wages Office Rent Utilities B Insurance Expense Depreciation Operating Income 5 Interest Expense Income before taxes Income taxes Net Income FORECASTED INCOME STATEMENT Assumptions YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Assets Cash Accounts Receivable Prepaid Insurance Current Assets Furniture & Fixtures (net) Equipment (net) Total Assets Liabilities Accounts payable Customer deposits Interest payable Taxes payable Current Liabilities Bank loan Total Liabilities Stockholder's Equity Capital Retained Earnings Total Stockholder's Equity Total Liabilities & Stockholder's Equity FORECASTED BALANCE SHEET YEAR 1 YEAR 2 Assumptions Assumption Explanations YEAR 3 YEAR 4 YEAR 5 Net Income Add back depreciation Changes in working capital Accounts Receivable Prepaid Expenses Accounts Payable Customer Deposits Interest payable Taxes Payable Cash flows from operating activities Amount paid for equipment Amount paid for furniture & fixtures Cash flow from investing activities Proceeds from bank loan Proceeds from issuing capital Repayment of bank loan Cash flow from financing activities Net increase (decrease) in cash Add: Beginning cash balance Ending Cash balance CASHFLOW STATEMENT Assumptions Assumption Explanations YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 2 1 RATIOS Formulas Show Work 3 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 4 *ROUND TO TWO DECIMAL PLACES 5 CURRENT RATIO 6 AVERAGE COLLECTION PERIOD 7 8 PAYABLES TURNOVER TOTAL ASSET TURNOVER 9 DEBT RATIO 10 TIMES INTEREST EARNED 11 GROSS PROFIT MARGIN 12 NET PROFIT MARGIN 13 RETURN ON EQUITY 14 15 16 17 Comment on the projected health of the company (Years 1-5) in terms of liquidity, activity, and profitability. As a financial analyst, what 18 suggestions would you make to Janelle to improve certain ratios. If you were the bank would you give Janelle the business loan? 19 20 21 22 23 24 25 26 27 28 29 30 31 32 22 Students will construct a set of forecasted financial statements and calculate a set of financial ratios for a start-up business. Note: Please read the documents related to forecasting financial statements under Documents & Resources in Week 4. Additionally, search online for information regarding forecasting financial statements. [Don't skip this step! It will provide background context and insight into what you'll be doing for this assignment.] You will notice that there are many methods to use to forecast financials. Some are quantitative while others are qualitative. Often, a mix of the two are used. There is no one exact way to perform forecasting. For the purpose of this assignment, you will be relying on the directions given under Forecasting Assumptions' to complete the Excel workbook. Case Overview Janelle Higgins has decided to start her own event planning business (JH Events) in the upcoming year. She believes that she has an innovative business model and is seeking a business loan. Therefore, Janelle is in the process of putting together a business plan. As part of her business plan, Janelle must include forecasted financial statements for the first 5 years. The forecasted financial statements to be included are: Income Statement, Balance Sheet, and Statement of Cash Flows. Janelle must also include a set of calculated ratios along with an overall assessment on the projected health of the company. Forecasting Assumptions • • First year sales are projected to be $150,000 and grow 3% for the next two years and 5% in year 4 and 5. Cost of sales are projected to be 45% of revenue in the first year and is expected to grow at the same rate as sales. • Advertising expenses are projected to be 4% of each year's projected revenue. Janelle will need to rent equipment for the events she puts on. She has an agreement with a rental company for a flat rate of $500 per month and is sufficient to cover all of her estimated events. Starting in Year 3, she expects to be able to handle more events and the rental rate will increase to $750 per month. • Janelle plans to start off by hiring 2 people to work the events with her. Each person will be paid $100 per event and is expected to work 4 events per month. After Year 3, Janelle plans to hire 2 additional people. (At this point, each person will be paid $100 per event and is expected to work 3 events per month). Office rent is estimated to be a flat rate of $1,200 per month. Utilities for the rented office space are estimated to be $300 per month. The office space Janelle plans to rent is unfurnished. She plans to purchase $15,000 worth of furniture and fixtures at the beginning of Year 1. The furniture and fixtures will have a useful life of 15 years. Janelle will also need to buy some computers and other • office equipment that she will purchase for $10,000 also at the beginning of Year 1. The office equipment will have a useful life of 5 years. Both the furniture and fixtures as well as the equipment will be depreciated on a straight-line basis (Assume zero salvage value for calculations). HINT: Fixed Assets - Accumulated Depreciation = 'Net' Fixed Assets Janelle is asking for a 3-year bank loan for $60,000 to be funded on Day1 of Year 1. The estimated interest on the loan is 3% (assume simple interest). She will pay the loan back in $20,000 installments starting in Year 2. Interest is due at the end of each year and paid in January of the following year. (Assume interest is paid on the principal balance still outstanding at year-end). The tax rate for JH Events is 35%. Taxes for the year just ended are payed in the first quarter of the following year. Janelle will invest $30,000 of her own money and from family and friends, before the beginning of the year, to start the business. This $30,000 investment of capital is also the beginning bank balance of Year 1. Schedule of expected year-end balances of selected accounts: Year 1 Year 2 Year 3 Year 4 Year 5 Accounts 10,000 12,000 8,000 6,000 10,000 Receivable Accounts 2,000 4,000 5,000 6,000 9,000 Payable Customer 1,500 2,000 3,000 4,000 5,000 Deposits • At the end of Year 2, Janelle will purchase an insurance policy to help cover the business. The policy has a term of 3 years and coverage starts at the beginning of Year 3. The policy costs $12,000. • During Year 3, Janelle plans to personally invest $10,000 of additional capital into the business. Chart of Accounts All accounts listed here should be included in your financial statements. • " Cash Accounts Receivable Prepaid Insurance ■ Furnitures & Fixtures Equipment " ■ Accounts Payable " Customer Deposits • Interest Payable Taxes Payable ■ Bank Loan Capital Retained Earnings Revenue Cost of Sales Advertising Equipment Rental Wages Office Rent Utilities Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells – do not alter these formulas. - ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotala on the 'Cash Flow State sier estac " " Equipment Rental Wages Office Rent " Utilities ■ " ■ Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance ☐ You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells - do not alter these formulas. ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotals on the 'Cash Flow Statement' tab for each major category) ☐ On each tab there is an area to keep track of the various assumptions. The column labeled 'Assumptions' is to make note of any numbers, percentages, etc. relevant to that line item. The column labeled ‘Assumption Explanations' is to help keep track of the 'Forecasting Assumptions' from above. (You can copy and paste the assumptions onto the relevant line item). On the ‘Ratios' tab there is an area to layout the formulas and show your work. ☐ There is a grading area on each tab that is being calculated as you input information. Please use this area to see where any mistakes are being made. ☐ You must upload your file to Blackboard under Week 5 Assignments (Include your name as part of the file name). Go to the Assignment, scroll down to "Attach Local File" and click Browse to select YOUR file, then hit SUBMIT. Revenue Cost of Sales Gross Margin Operating Expenses Advertising Equipment Rental Wages Office Rent Utilities B Insurance Expense Depreciation Operating Income 5 Interest Expense Income before taxes Income taxes Net Income FORECASTED INCOME STATEMENT Assumptions YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Assets Cash Accounts Receivable Prepaid Insurance Current Assets Furniture & Fixtures (net) Equipment (net) Total Assets Liabilities Accounts payable Customer deposits Interest payable Taxes payable Current Liabilities Bank loan Total Liabilities Stockholder's Equity Capital Retained Earnings Total Stockholder's Equity Total Liabilities & Stockholder's Equity FORECASTED BALANCE SHEET YEAR 1 YEAR 2 Assumptions Assumption Explanations YEAR 3 YEAR 4 YEAR 5 Net Income Add back depreciation Changes in working capital Accounts Receivable Prepaid Expenses Accounts Payable Customer Deposits Interest payable Taxes Payable Cash flows from operating activities Amount paid for equipment Amount paid for furniture & fixtures Cash flow from investing activities Proceeds from bank loan Proceeds from issuing capital Repayment of bank loan Cash flow from financing activities Net increase (decrease) in cash Add: Beginning cash balance Ending Cash balance CASHFLOW STATEMENT Assumptions Assumption Explanations YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 2 1 RATIOS Formulas Show Work 3 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 4 *ROUND TO TWO DECIMAL PLACES 5 CURRENT RATIO 6 AVERAGE COLLECTION PERIOD 7 8 PAYABLES TURNOVER TOTAL ASSET TURNOVER 9 DEBT RATIO 10 TIMES INTEREST EARNED 11 GROSS PROFIT MARGIN 12 NET PROFIT MARGIN 13 RETURN ON EQUITY 14 15 16 17 Comment on the projected health of the company (Years 1-5) in terms of liquidity, activity, and profitability. As a financial analyst, what 18 suggestions would you make to Janelle to improve certain ratios. If you were the bank would you give Janelle the business loan? 19 20 21 22 23 24 25 26 27 28 29 30 31 32 22 Students will construct a set of forecasted financial statements and calculate a set of financial ratios for a start-up business. Note: Please read the documents related to forecasting financial statements under Documents & Resources in Week 4. Additionally, search online for information regarding forecasting financial statements. [Don't skip this step! It will provide background context and insight into what you'll be doing for this assignment.] You will notice that there are many methods to use to forecast financials. Some are quantitative while others are qualitative. Often, a mix of the two are used. There is no one exact way to perform forecasting. For the purpose of this assignment, you will be relying on the directions given under Forecasting Assumptions' to complete the Excel workbook. Case Overview Janelle Higgins has decided to start her own event planning business (JH Events) in the upcoming year. She believes that she has an innovative business model and is seeking a business loan. Therefore, Janelle is in the process of putting together a business plan. As part of her business plan, Janelle must include forecasted financial statements for the first 5 years. The forecasted financial statements to be included are: Income Statement, Balance Sheet, and Statement of Cash Flows. Janelle must also include a set of calculated ratios along with an overall assessment on the projected health of the company. Forecasting Assumptions • • First year sales are projected to be $150,000 and grow 3% for the next two years and 5% in year 4 and 5. Cost of sales are projected to be 45% of revenue in the first year and is expected to grow at the same rate as sales. • Advertising expenses are projected to be 4% of each year's projected revenue. Janelle will need to rent equipment for the events she puts on. She has an agreement with a rental company for a flat rate of $500 per month and is sufficient to cover all of her estimated events. Starting in Year 3, she expects to be able to handle more events and the rental rate will increase to $750 per month. • Janelle plans to start off by hiring 2 people to work the events with her. Each person will be paid $100 per event and is expected to work 4 events per month. After Year 3, Janelle plans to hire 2 additional people. (At this point, each person will be paid $100 per event and is expected to work 3 events per month). Office rent is estimated to be a flat rate of $1,200 per month. Utilities for the rented office space are estimated to be $300 per month. The office space Janelle plans to rent is unfurnished. She plans to purchase $15,000 worth of furniture and fixtures at the beginning of Year 1. The furniture and fixtures will have a useful life of 15 years. Janelle will also need to buy some computers and other Students will construct a set of forecasted financial statements and calculate a set of financial ratios for a start-up business. Note: Please read the documents related to forecasting financial statements under Documents & Resources in Week 4. Additionally, search online for information regarding forecasting financial statements. [Don't skip this step! It will provide background context and insight into what you'll be doing for this assignment.] You will notice that there are many methods to use to forecast financials. Some are quantitative while others are qualitative. Often, a mix of the two are used. There is no one exact way to perform forecasting. For the purpose of this assignment, you will be relying on the directions given under Forecasting Assumptions' to complete the Excel workbook. Case Overview Janelle Higgins has decided to start her own event planning business (JH Events) in the upcoming year. She believes that she has an innovative business model and is seeking a business loan. Therefore, Janelle is in the process of putting together a business plan. As part of her business plan, Janelle must include forecasted financial statements for the first 5 years. The forecasted financial statements to be included are: Income Statement, Balance Sheet, and Statement of Cash Flows. Janelle must also include a set of calculated ratios along with an overall assessment on the projected health of the company. Forecasting Assumptions • • First year sales are projected to be $150,000 and grow 3% for the next two years and 5% in year 4 and 5. Cost of sales are projected to be 45% of revenue in the first year and is expected to grow at the same rate as sales. • Advertising expenses are projected to be 4% of each year's projected revenue. Janelle will need to rent equipment for the events she puts on. She has an agreement with a rental company for a flat rate of $500 per month and is sufficient to cover all of her estimated events. Starting in Year 3, she expects to be able to handle more events and the rental rate will increase to $750 per month. • Janelle plans to start off by hiring 2 people to work the events with her. Each person will be paid $100 per event and is expected to work 4 events per month. After Year 3, Janelle plans to hire 2 additional people. (At this point, each person will be paid $100 per event and is expected to work 3 events per month). Office rent is estimated to be a flat rate of $1,200 per month. Utilities for the rented office space are estimated to be $300 per month. The office space Janelle plans to rent is unfurnished. She plans to purchase $15,000 worth of furniture and fixtures at the beginning of Year 1. The furniture and fixtures will have a useful life of 15 years. Janelle will also need to buy some computers and other • office equipment that she will purchase for $10,000 also at the beginning of Year 1. The office equipment will have a useful life of 5 years. Both the furniture and fixtures as well as the equipment will be depreciated on a straight-line basis (Assume zero salvage value for calculations). HINT: Fixed Assets - Accumulated Depreciation = 'Net' Fixed Assets Janelle is asking for a 3-year bank loan for $60,000 to be funded on Day1 of Year 1. The estimated interest on the loan is 3% (assume simple interest). She will pay the loan back in $20,000 installments starting in Year 2. Interest is due at the end of each year and paid in January of the following year. (Assume interest is paid on the principal balance still outstanding at year-end). The tax rate for JH Events is 35%. Taxes for the year just ended are payed in the first quarter of the following year. Janelle will invest $30,000 of her own money and from family and friends, before the beginning of the year, to start the business. This $30,000 investment of capital is also the beginning bank balance of Year 1. Schedule of expected year-end balances of selected accounts: Year 1 Year 2 Year 3 Year 4 Year 5 Accounts 10,000 12,000 8,000 6,000 10,000 Receivable Accounts 2,000 4,000 5,000 6,000 9,000 Payable Customer 1,500 2,000 3,000 4,000 5,000 Deposits • At the end of Year 2, Janelle will purchase an insurance policy to help cover the business. The policy has a term of 3 years and coverage starts at the beginning of Year 3. The policy costs $12,000. • During Year 3, Janelle plans to personally invest $10,000 of additional capital into the business. Chart of Accounts All accounts listed here should be included in your financial statements. • " Cash Accounts Receivable Prepaid Insurance ■ Furnitures & Fixtures Equipment " ■ Accounts Payable " Customer Deposits • Interest Payable Taxes Payable ■ Bank Loan • office equipment that she will purchase for $10,000 also at the beginning of Year 1. The office equipment will have a useful life of 5 years. Both the furniture and fixtures as well as the equipment will be depreciated on a straight-line basis (Assume zero salvage value for calculations). HINT: Fixed Assets - Accumulated Depreciation = 'Net' Fixed Assets Janelle is asking for a 3-year bank loan for $60,000 to be funded on Day1 of Year 1. The estimated interest on the loan is 3% (assume simple interest). She will pay the loan back in $20,000 installments starting in Year 2. Interest is due at the end of each year and paid in January of the following year. (Assume interest is paid on the principal balance still outstanding at year-end). The tax rate for JH Events is 35%. Taxes for the year just ended are payed in the first quarter of the following year. Janelle will invest $30,000 of her own money and from family and friends, before the beginning of the year, to start the business. This $30,000 investment of capital is also the beginning bank balance of Year 1. Schedule of expected year-end balances of selected accounts: Year 1 Year 2 Year 3 Year 4 Year 5 Accounts 10,000 12,000 8,000 6,000 10,000 Receivable Accounts 2,000 4,000 5,000 6,000 9,000 Payable Customer 1,500 2,000 3,000 4,000 5,000 Deposits • At the end of Year 2, Janelle will purchase an insurance policy to help cover the business. The policy has a term of 3 years and coverage starts at the beginning of Year 3. The policy costs $12,000. • During Year 3, Janelle plans to personally invest $10,000 of additional capital into the business. Chart of Accounts All accounts listed here should be included in your financial statements. • " Cash Accounts Receivable Prepaid Insurance ■ Furnitures & Fixtures Equipment " ■ Accounts Payable " Customer Deposits • Interest Payable Taxes Payable ■ Bank Loan Capital Retained Earnings Revenue Cost of Sales Advertising Equipment Rental Wages Office Rent Utilities Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells – do not alter these formulas. - ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotala on the 'Cash Flow State sier estac Capital Retained Earnings Revenue Cost of Sales Advertising Equipment Rental Wages Office Rent Utilities Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells – do not alter these formulas. - ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotala on the 'Cash Flow State sier estac " " Equipment Rental Wages Office Rent " Utilities ■ " ■ Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance ☐ You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells - do not alter these formulas. ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotals on the 'Cash Flow Statement' tab for each major category) ☐ On each tab there is an area to keep track of the various assumptions. The column labeled 'Assumptions' is to make note of any numbers, percentages, etc. relevant to that line item. The column labeled ‘Assumption Explanations' is to help keep track of the 'Forecasting Assumptions' from above. (You can copy and paste the assumptions onto the relevant line item). On the ‘Ratios' tab there is an area to layout the formulas and show your work. ☐ There is a grading area on each tab that is being calculated as you input information. Please use this area to see where any mistakes are being made. ☐ You must upload your file to Blackboard under Week 5 Assignments (Include your name as part of the file name). Go to the Assignment, scroll down to "Attach Local File" and click Browse to select YOUR file, then hit SUBMIT. " " Equipment Rental Wages Office Rent " Utilities ■ " ■ Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance ☐ You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells - do not alter these formulas. ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotals on the 'Cash Flow Statement' tab for each major category) ☐ On each tab there is an area to keep track of the various assumptions. The column labeled 'Assumptions' is to make note of any numbers, percentages, etc. relevant to that line item. The column labeled ‘Assumption Explanations' is to help keep track of the 'Forecasting Assumptions' from above. (You can copy and paste the assumptions onto the relevant line item). On the ‘Ratios' tab there is an area to layout the formulas and show your work. ☐ There is a grading area on each tab that is being calculated as you input information. Please use this area to see where any mistakes are being made. ☐ You must upload your file to Blackboard under Week 5 Assignments (Include your name as part of the file name). Go to the Assignment, scroll down to "Attach Local File" and click Browse to select YOUR file, then hit SUBMIT. Revenue Cost of Sales Gross Margin Operating Expenses Advertising Equipment Rental Wages Office Rent Utilities B Insurance Expense Depreciation Operating Income 5 Interest Expense Income before taxes Income taxes Net Income FORECASTED INCOME STATEMENT Assumptions YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Revenue Cost of Sales Gross Margin Operating Expenses Advertising Equipment Rental Wages Office Rent Utilities B Insurance Expense Depreciation Operating Income 5 Interest Expense Income before taxes Income taxes Net Income FORECASTED INCOME STATEMENT Assumptions YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Assets Cash Accounts Receivable Prepaid Insurance Current Assets Furniture & Fixtures (net) Equipment (net) Total Assets Liabilities Accounts payable Customer deposits Interest payable Taxes payable Current Liabilities Bank loan Total Liabilities Stockholder's Equity Capital Retained Earnings Total Stockholder's Equity Total Liabilities & Stockholder's Equity FORECASTED BALANCE SHEET YEAR 1 YEAR 2 Assumptions Assumption Explanations YEAR 3 YEAR 4 YEAR 5 Assets Cash Accounts Receivable Prepaid Insurance Current Assets Furniture & Fixtures (net) Equipment (net) Total Assets Liabilities Accounts payable Customer deposits Interest payable Taxes payable Current Liabilities Bank loan Total Liabilities Stockholder's Equity Capital Retained Earnings Total Stockholder's Equity Total Liabilities & Stockholder's Equity FORECASTED BALANCE SHEET YEAR 1 YEAR 2 Assumptions Assumption Explanations YEAR 3 YEAR 4 YEAR 5 Net Income Add back depreciation Changes in working capital Accounts Receivable Prepaid Expenses Accounts Payable Customer Deposits Interest payable Taxes Payable Cash flows from operating activities Amount paid for equipment Amount paid for furniture & fixtures Cash flow from investing activities Proceeds from bank loan Proceeds from issuing capital Repayment of bank loan Cash flow from financing activities Net increase (decrease) in cash Add: Beginning cash balance Ending Cash balance CASHFLOW STATEMENT Assumptions Assumption Explanations YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 2 Net Income Add back depreciation Changes in working capital Accounts Receivable Prepaid Expenses Accounts Payable Customer Deposits Interest payable Taxes Payable Cash flows from operating activities Amount paid for equipment Amount paid for furniture & fixtures Cash flow from investing activities Proceeds from bank loan Proceeds from issuing capital Repayment of bank loan Cash flow from financing activities Net increase (decrease) in cash Add: Beginning cash balance Ending Cash balance CASHFLOW STATEMENT Assumptions Assumption Explanations YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 2 1 RATIOS Formulas Show Work 3 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 4 *ROUND TO TWO DECIMAL PLACES 5 CURRENT RATIO 6 AVERAGE COLLECTION PERIOD 7 8 PAYABLES TURNOVER TOTAL ASSET TURNOVER 9 DEBT RATIO 10 TIMES INTEREST EARNED 11 GROSS PROFIT MARGIN 12 NET PROFIT MARGIN 13 RETURN ON EQUITY 14 15 16 17 Comment on the projected health of the company (Years 1-5) in terms of liquidity, activity, and profitability. As a financial analyst, what 18 suggestions would you make to Janelle to improve certain ratios. If you were the bank would you give Janelle the business loan? 19 20 21 22 23 24 25 26 27 28 29 30 31 32 22 1 RATIOS Formulas Show Work 3 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 4 *ROUND TO TWO DECIMAL PLACES 5 CURRENT RATIO 6 AVERAGE COLLECTION PERIOD 7 8 PAYABLES TURNOVER TOTAL ASSET TURNOVER 9 DEBT RATIO 10 TIMES INTEREST EARNED 11 GROSS PROFIT MARGIN 12 NET PROFIT MARGIN 13 RETURN ON EQUITY 14 15 16 17 Comment on the projected health of the company (Years 1-5) in terms of liquidity, activity, and profitability. As a financial analyst, what 18 suggestions would you make to Janelle to improve certain ratios. If you were the bank would you give Janelle the business loan? 19 20 21 22 23 24 25 26 27 28 29 30 31 32 22 Students will construct a set of forecasted financial statements and calculate a set of financial ratios for a start-up business. Note: Please read the documents related to forecasting financial statements under Documents & Resources in Week 4. Additionally, search online for information regarding forecasting financial statements. [Don't skip this step! It will provide background context and insight into what you'll be doing for this assignment.] You will notice that there are many methods to use to forecast financials. Some are quantitative while others are qualitative. Often, a mix of the two are used. There is no one exact way to perform forecasting. For the purpose of this assignment, you will be relying on the directions given under Forecasting Assumptions' to complete the Excel workbook. Case Overview Janelle Higgins has decided to start her own event planning business (JH Events) in the upcoming year. She believes that she has an innovative business model and is seeking a business loan. Therefore, Janelle is in the process of putting together a business plan. As part of her business plan, Janelle must include forecasted financial statements for the first 5 years. The forecasted financial statements to be included are: Income Statement, Balance Sheet, and Statement of Cash Flows. Janelle must also include a set of calculated ratios along with an overall assessment on the projected health of the company. Forecasting Assumptions • • First year sales are projected to be $150,000 and grow 3% for the next two years and 5% in year 4 and 5. Cost of sales are projected to be 45% of revenue in the first year and is expected to grow at the same rate as sales. • Advertising expenses are projected to be 4% of each year's projected revenue. Janelle will need to rent equipment for the events she puts on. She has an agreement with a rental company for a flat rate of $500 per month and is sufficient to cover all of her estimated events. Starting in Year 3, she expects to be able to handle more events and the rental rate will increase to $750 per month. • Janelle plans to start off by hiring 2 people to work the events with her. Each person will be paid $100 per event and is expected to work 4 events per month. After Year 3, Janelle plans to hire 2 additional people. (At this point, each person will be paid $100 per event and is expected to work 3 events per month). Office rent is estimated to be a flat rate of $1,200 per month. Utilities for the rented office space are estimated to be $300 per month. The office space Janelle plans to rent is unfurnished. She plans to purchase $15,000 worth of furniture and fixtures at the beginning of Year 1. The furniture and fixtures will have a useful life of 15 years. Janelle will also need to buy some computers and other Students will construct a set of forecasted financial statements and calculate a set of financial ratios for a start-up business. Note: Please read the documents related to forecasting financial statements under Documents & Resources in Week 4. Additionally, search online for information regarding forecasting financial statements. [Don't skip this step! It will provide background context and insight into what you'll be doing for this assignment.] You will notice that there are many methods to use to forecast financials. Some are quantitative while others are qualitative. Often, a mix of the two are used. There is no one exact way to perform forecasting. For the purpose of this assignment, you will be relying on the directions given under Forecasting Assumptions' to complete the Excel workbook. Case Overview Janelle Higgins has decided to start her own event planning business (JH Events) in the upcoming year. She believes that she has an innovative business model and is seeking a business loan. Therefore, Janelle is in the process of putting together a business plan. As part of her business plan, Janelle must include forecasted financial statements for the first 5 years. The forecasted financial statements to be included are: Income Statement, Balance Sheet, and Statement of Cash Flows. Janelle must also include a set of calculated ratios along with an overall assessment on the projected health of the company. Forecasting Assumptions • • First year sales are projected to be $150,000 and grow 3% for the next two years and 5% in year 4 and 5. Cost of sales are projected to be 45% of revenue in the first year and is expected to grow at the same rate as sales. • Advertising expenses are projected to be 4% of each year's projected revenue. Janelle will need to rent equipment for the events she puts on. She has an agreement with a rental company for a flat rate of $500 per month and is sufficient to cover all of her estimated events. Starting in Year 3, she expects to be able to handle more events and the rental rate will increase to $750 per month. • Janelle plans to start off by hiring 2 people to work the events with her. Each person will be paid $100 per event and is expected to work 4 events per month. After Year 3, Janelle plans to hire 2 additional people. (At this point, each person will be paid $100 per event and is expected to work 3 events per month). Office rent is estimated to be a flat rate of $1,200 per month. Utilities for the rented office space are estimated to be $300 per month. The office space Janelle plans to rent is unfurnished. She plans to purchase $15,000 worth of furniture and fixtures at the beginning of Year 1. The furniture and fixtures will have a useful life of 15 years. Janelle will also need to buy some computers and other • office equipment that she will purchase for $10,000 also at the beginning of Year 1. The office equipment will have a useful life of 5 years. Both the furniture and fixtures as well as the equipment will be depreciated on a straight-line basis (Assume zero salvage value for calculations). HINT: Fixed Assets - Accumulated Depreciation = 'Net' Fixed Assets Janelle is asking for a 3-year bank loan for $60,000 to be funded on Day1 of Year 1. The estimated interest on the loan is 3% (assume simple interest). She will pay the loan back in $20,000 installments starting in Year 2. Interest is due at the end of each year and paid in January of the following year. (Assume interest is paid on the principal balance still outstanding at year-end). The tax rate for JH Events is 35%. Taxes for the year just ended are payed in the first quarter of the following year. Janelle will invest $30,000 of her own money and from family and friends, before the beginning of the year, to start the business. This $30,000 investment of capital is also the beginning bank balance of Year 1. Schedule of expected year-end balances of selected accounts: Year 1 Year 2 Year 3 Year 4 Year 5 Accounts 10,000 12,000 8,000 6,000 10,000 Receivable Accounts 2,000 4,000 5,000 6,000 9,000 Payable Customer 1,500 2,000 3,000 4,000 5,000 Deposits • At the end of Year 2, Janelle will purchase an insurance policy to help cover the business. The policy has a term of 3 years and coverage starts at the beginning of Year 3. The policy costs $12,000. • During Year 3, Janelle plans to personally invest $10,000 of additional capital into the business. Chart of Accounts All accounts listed here should be included in your financial statements. • " Cash Accounts Receivable Prepaid Insurance ■ Furnitures & Fixtures Equipment " ■ Accounts Payable " Customer Deposits • Interest Payable Taxes Payable ■ Bank Loan • office equipment that she will purchase for $10,000 also at the beginning of Year 1. The office equipment will have a useful life of 5 years. Both the furniture and fixtures as well as the equipment will be depreciated on a straight-line basis (Assume zero salvage value for calculations). HINT: Fixed Assets - Accumulated Depreciation = 'Net' Fixed Assets Janelle is asking for a 3-year bank loan for $60,000 to be funded on Day1 of Year 1. The estimated interest on the loan is 3% (assume simple interest). She will pay the loan back in $20,000 installments starting in Year 2. Interest is due at the end of each year and paid in January of the following year. (Assume interest is paid on the principal balance still outstanding at year-end). The tax rate for JH Events is 35%. Taxes for the year just ended are payed in the first quarter of the following year. Janelle will invest $30,000 of her own money and from family and friends, before the beginning of the year, to start the business. This $30,000 investment of capital is also the beginning bank balance of Year 1. Schedule of expected year-end balances of selected accounts: Year 1 Year 2 Year 3 Year 4 Year 5 Accounts 10,000 12,000 8,000 6,000 10,000 Receivable Accounts 2,000 4,000 5,000 6,000 9,000 Payable Customer 1,500 2,000 3,000 4,000 5,000 Deposits • At the end of Year 2, Janelle will purchase an insurance policy to help cover the business. The policy has a term of 3 years and coverage starts at the beginning of Year 3. The policy costs $12,000. • During Year 3, Janelle plans to personally invest $10,000 of additional capital into the business. Chart of Accounts All accounts listed here should be included in your financial statements. • " Cash Accounts Receivable Prepaid Insurance ■ Furnitures & Fixtures Equipment " ■ Accounts Payable " Customer Deposits • Interest Payable Taxes Payable ■ Bank Loan Capital Retained Earnings Revenue Cost of Sales Advertising Equipment Rental Wages Office Rent Utilities Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells – do not alter these formulas. - ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotala on the 'Cash Flow State sier estac Capital Retained Earnings Revenue Cost of Sales Advertising Equipment Rental Wages Office Rent Utilities Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells – do not alter these formulas. - ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotala on the 'Cash Flow State sier estac " " Equipment Rental Wages Office Rent " Utilities ■ " ■ Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance ☐ You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells - do not alter these formulas. ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotals on the 'Cash Flow Statement' tab for each major category) ☐ On each tab there is an area to keep track of the various assumptions. The column labeled 'Assumptions' is to make note of any numbers, percentages, etc. relevant to that line item. The column labeled ‘Assumption Explanations' is to help keep track of the 'Forecasting Assumptions' from above. (You can copy and paste the assumptions onto the relevant line item). On the ‘Ratios' tab there is an area to layout the formulas and show your work. ☐ There is a grading area on each tab that is being calculated as you input information. Please use this area to see where any mistakes are being made. ☐ You must upload your file to Blackboard under Week 5 Assignments (Include your name as part of the file name). Go to the Assignment, scroll down to "Attach Local File" and click Browse to select YOUR file, then hit SUBMIT. " " Equipment Rental Wages Office Rent " Utilities ■ " ■ Insurance Expense Depreciation Interest Expense Income Taxes Additional Instructions & Guidance ☐ You must use the given Excel template attached to this assignment. ☐ The three financial statements are interconnected. Where applicable, reference the appropriate cells from other tabs. Also, use formulas within the cells where applicable. (Instructors may deduct points for not using cell references and formulas.) There are some formulas already included in various cells - do not alter these formulas. ☐ Some cells have additional notes (cells marked with a red triangle in the upper right-hand corner; hover over the triangle to see the note). ☐ Review Chapter 4 for helpful information in completing the Cash Flow Statement. ☐ The shaded areas are for data input. (NOTE: You will need to enter formulas to calculate subtotals on the 'Cash Flow Statement' tab for each major category) ☐ On each tab there is an area to keep track of the various assumptions. The column labeled 'Assumptions' is to make note of any numbers, percentages, etc. relevant to that line item. The column labeled ‘Assumption Explanations' is to help keep track of the 'Forecasting Assumptions' from above. (You can copy and paste the assumptions onto the relevant line item). On the ‘Ratios' tab there is an area to layout the formulas and show your work. ☐ There is a grading area on each tab that is being calculated as you input information. Please use this area to see where any mistakes are being made. ☐ You must upload your file to Blackboard under Week 5 Assignments (Include your name as part of the file name). Go to the Assignment, scroll down to "Attach Local File" and click Browse to select YOUR file, then hit SUBMIT. Revenue Cost of Sales Gross Margin Operating Expenses Advertising Equipment Rental Wages Office Rent Utilities B Insurance Expense Depreciation Operating Income 5 Interest Expense Income before taxes Income taxes Net Income FORECASTED INCOME STATEMENT Assumptions YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Revenue Cost of Sales Gross Margin Operating Expenses Advertising Equipment Rental Wages Office Rent Utilities B Insurance Expense Depreciation Operating Income 5 Interest Expense Income before taxes Income taxes Net Income FORECASTED INCOME STATEMENT Assumptions YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Assets Cash Accounts Receivable Prepaid Insurance Current Assets Furniture & Fixtures (net) Equipment (net) Total Assets Liabilities Accounts payable Customer deposits Interest payable Taxes payable Current Liabilities Bank loan Total Liabilities Stockholder's Equity Capital Retained Earnings Total Stockholder's Equity Total Liabilities & Stockholder's Equity FORECASTED BALANCE SHEET YEAR 1 YEAR 2 Assumptions Assumption Explanations YEAR 3 YEAR 4 YEAR 5 Assets Cash Accounts Receivable Prepaid Insurance Current Assets Furniture & Fixtures (net) Equipment (net) Total Assets Liabilities Accounts payable Customer deposits Interest payable Taxes payable Current Liabilities Bank loan Total Liabilities Stockholder's Equity Capital Retained Earnings Total Stockholder's Equity Total Liabilities & Stockholder's Equity FORECASTED BALANCE SHEET YEAR 1 YEAR 2 Assumptions Assumption Explanations YEAR 3 YEAR 4 YEAR 5 Net Income Add back depreciation Changes in working capital Accounts Receivable Prepaid Expenses Accounts Payable Customer Deposits Interest payable Taxes Payable Cash flows from operating activities Amount paid for equipment Amount paid for furniture & fixtures Cash flow from investing activities Proceeds from bank loan Proceeds from issuing capital Repayment of bank loan Cash flow from financing activities Net increase (decrease) in cash Add: Beginning cash balance Ending Cash balance CASHFLOW STATEMENT Assumptions Assumption Explanations YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 2 Net Income Add back depreciation Changes in working capital Accounts Receivable Prepaid Expenses Accounts Payable Customer Deposits Interest payable Taxes Payable Cash flows from operating activities Amount paid for equipment Amount paid for furniture & fixtures Cash flow from investing activities Proceeds from bank loan Proceeds from issuing capital Repayment of bank loan Cash flow from financing activities Net increase (decrease) in cash Add: Beginning cash balance Ending Cash balance CASHFLOW STATEMENT Assumptions Assumption Explanations YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 2 1 RATIOS Formulas Show Work 3 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 4 *ROUND TO TWO DECIMAL PLACES 5 CURRENT RATIO 6 AVERAGE COLLECTION PERIOD 7 8 PAYABLES TURNOVER TOTAL ASSET TURNOVER 9 DEBT RATIO 10 TIMES INTEREST EARNED 11 GROSS PROFIT MARGIN 12 NET PROFIT MARGIN 13 RETURN ON EQUITY 14 15 16 17 Comment on the projected health of the company (Years 1-5) in terms of liquidity, activity, and profitability. As a financial analyst, what 18 suggestions would you make to Janelle to improve certain ratios. If you were the bank would you give Janelle the business loan? 19 20 21 22 23 24 25 26 27 28 29 30 31 32 22 1 RATIOS Formulas Show Work 3 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 4 *ROUND TO TWO DECIMAL PLACES 5 CURRENT RATIO 6 AVERAGE COLLECTION PERIOD 7 8 PAYABLES TURNOVER TOTAL ASSET TURNOVER 9 DEBT RATIO 10 TIMES INTEREST EARNED 11 GROSS PROFIT MARGIN 12 NET PROFIT MARGIN 13 RETURN ON EQUITY 14 15 16 17 Comment on the projected health of the company (Years 1-5) in terms of liquidity, activity, and profitability. As a financial analyst, what 18 suggestions would you make to Janelle to improve certain ratios. If you were the bank would you give Janelle the business loan? 19 20 21 22 23 24 25 26 27 28 29 30 31 32 22
Expert Answer:
Related Book For
Fundamental financial accounting concepts
ISBN: 978-0078025365
8th edition
Authors: Thomas P. Edmonds, Frances M. Mcnair, Philip R. Olds, Edward
Posted Date:
Students also viewed these accounting questions
-
Senior leadership at Matrix International Corporation now has a strong understanding of the importance of performance management and its value to the company. Their knowledge came as a result of the...
-
Using the company that you selected for Assignment #1- Examining Financial Statements you will be conducting an investor analysis. You will also need to select two additional companies within the...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
What is project scoping? Why is it important to good problem solving?
-
The Axiom of Completeness for the real numbers says: Every set of real numbers that has an upper bound has a least upper bound that is a real number. (a) Show that the italicized statement is false...
-
Annie B's Homemade Ice Cream is an ice cream shop in Asheville, NC. Annie's Homemade is considering selling its ice cream to a regional supermarket chain that would attach a markup to the ice cream...
-
Which of the following statements is false? a. A flowchart is an analytical technique used to describe some aspect of an information system in a clear, concise, and logical manner. b. Flowcharts use...
-
Nami Yee is a contractor specializing in custom-built jacuzzis. On May 1, 2012, her ledger contains the following data.Raw Materials Inventory ..... $30,000Work in Process Inventory ......
-
a. Kristi is considering an investment that will pay $7,500 a year for eight years, starting one year from today. How much should she pay for this investment if she wishes to earn a 6% rate of...
-
Using the below Adjusted Trial Balance, complete Reuben's Cubic Storage Income Statement. Statement of Changes to Owner's Equity and their Balance Sheet. When completing the Statement of Changes in...
-
For the data samples shown in figure below, answer to the following questions. a) Draw and label the classifier lines on the figure. b) Design a neural network that can be used for the following...
-
What training ideas would you propose to engage and motivate today's healthcare employees?
-
Zia Company makes flowerpots from recycled plastic in two departments, Molding and Packaging. Zia uses the weighted average method, and units completed in the Molding department are transferred to...
-
3. Find (a) a basis for and (b) the dimension of the subspace of R4. W = {(2st, s, t, s): s and t are real numbers}
-
Robotic bees are tiny drones that can be used for a number of purposes other than pollinating flowers. They can be used for environmental monitoring, biological studies, and search and rescue...
-
Ingrid Boes, an Alberta employee, is being released from employment in April of the current year after 11 years of service. Ingrid's regular semi-monthly salary is $2,790.00. Calculate the gross...
-
(b) The following figures give the prices in rupees of a certain commodity in a sample of 15 shops selected at random from a city A and those in a sample of 13 shops from another city B: City A City...
-
Consider the following cash flows in Table P5.5. (a) Calculate the payback period for each project. (b) Determine whether it is meaningful to calculate a payback period for project D. (c) Assuming...
-
Garden Gifts Inc. had cash sales of $112,500 for 2013, its first year of operation. On April 2, the company purchased 150 units of inventory at $180 per unit. On September 1, an additional 200 units...
-
On May 1, 2013, Sturgis Corporation declared a $100,000 cash dividend to be paid on May 31 to shareholders of record on May 15. Required a. Record the events occurring on May 1, May 15, and May 31 in...
-
Determining the cost of inventory Required For each of the following cases determine the ending balance in the inventory account. a. Monas Dress Shop had a beginning balance in its inventory account...
-
The Rankine Corporation reported net income of \($10\) million in 2016, and it appears that net income for 2017 will be the same. During 2017, the company made the following expenditures: 1....
-
The following cash flow information was taken from the 2015 annual report for Johnson & Johnson. Compute the missing values in the table (amounts are in millions). Based on this data, how does the...
-
The following cash flow information was taken from the 2015 annual report for General Electric. Compute the missing values in the table (amounts are in millions). Based on this data, describe GEs...
Study smarter with the SolutionInn App