I'm currently taking a course in Financial Analysis in the Hospitality Industry. Could you please answer the 4 individual questions in each tab of the attached excel file? Thank You.

See Chapter 5 Hospitality Finance-EXCEL.xlsx

Chapter 5, Question 1 Marvin Pearson is the managerial accountant for Highway Subs, a chain of sandwich shops located at major Interstate highway exits. He is about to begin work on a statement of cash ows for his organization and needs a quick refresher. Help him out by labeling each of the following items as a Source or Use of funds. Place an ''S'' before the statements identifying a source of funds, and a ''U'' for those statements identifying a use of funds. a. b. c. d. e. f. g. h. i. j. k. l. m. n. o. p. q. r. s. t. Chapter 5 Q1 Increase in cash Decrease in marketable securities Decrease in net receivables Increase in inventories Increase in property and equipment Decrease in common stock Decrease in cash Increase in retained earnings Increase in notes payable Decrease in inventories Increase in common stock Decrease in accounts payable Decrease in long-term debt Increase in marketable securities Decrease in property and equipment Increase in long-term debt Decrease in notes payable Increase in accounts payable Increase in net receivables Increase in depreciation Chapter 5, Question 2 The Fred Proffet Company has been in the contract food service management business for many years. Their clients chose the Proffet Company for its creativity and attention to detail. Allisha McKay is the person who prepares the summary of sources and uses of funds for the Proffet Company. Help her do that by using the balance sheets that follow to calculate the company's sources and uses of funds, and answer the questions that follow. The Fred Proffet Company Balance Sheets December 31, 2011 and 2012 2011 Assets Current Assets Cash Marketable Securities Net Receivables Inventories Total Current Assets 2012 Sources Uses 336,000 350,000 1,240,000 1,200,000 1,520,000 1,550,000 844,000 830,000 3,940,000 3,930,000 Property and Equipment 1,200,000 1,500,000 Less Accumulated Depreciation 420,000 525,000 Net Property and Equipment 780,000 975,000 Total Assets 4,720,000 4,905,000 Liabilities and Owners' Equity Current Liabilities Accounts Payable Notes Payable Other Current Liabilities Total Current Liabilities 584,000 134,000 636,000 1,354,000 Long-Term Liabilities Long-Term Debt Total Liabilities 720,000 1,100,000 2,074,000 2,055,000 Owners' Equity Common Stock Paid in Capital Retained Earnings Total Owners' Equity 300,000 320,000 1,200,000 1,280,000 1,146,000 1,250,000 2,646,000 2,850,000 565,000 90,000 300,000 955,000 Total Liabilities and Owner's Equity 4,720,000 4,905,000 Total Sources and Uses of Funds a. Did the change in Cash reflect a Source or a Use of funds? What was the amount of that change? b. Did the change in Net Receivables reflect a Source or a Use of funds? What was the amount of that change? c. Did the change in Notes Payable reflect a Source or a Use of funds? What was the amount of that change? d. Did the change in Retained Earnings reflect a Source or a Use of funds? What was the amount of that change? e. What was the total amount of Sources and Uses of Funds? Answers: a. b. c. d. e. Chapter 5 Q2 Chapter 5, Question 3 Now that Allisha McKay (see Question 2 tab) has compiled the sources and uses of funds information she needs, she is ready to prepare The Fred Proffet Company's Statement of Cash Flows for the Year Ended 2012. Help her complete the company's Statement of Cash Flows by using the information taken from the following Condensed Income Statement and Statement of Retained Earnings for 2012, and the 2011 and 2012 Balance Sheets in Question 2. Then, answer the questions that follow: The Fred Proffet Company Condensed Income Statement and Statement of Retained Earnings For the Period: January 1 through December 31, 2012 Income Statement Sales $5,200,000 Cost of Sales Gross Profit Operating Expenses (excluding depreciation) 1,560,000 3,640,000 2,860,000 Depreciation Operating Income 105,000 675,000 Interest Income Before Income Taxes 242,000 433,000 Income Taxes (40%) Net Income 173,000 260,000 Statement of Retained Earnings Retained Earnings, December 31, 2011 Net Income for 2012 1,146,000 260,000 Subtotal 1,406,000 Cash Dividends Paid in 2012 Retained Earnings, December 31, 2012 156,000 1,250,000 The Fred Proffet Company Statement of Cash Flows 31-Dec-12 Net Cash Flow from Operating Activities Net Income Adjustments to reconcile net income to net cash flows from operating activities Depreciation Increase in Net Receivables Decrease in Inventories Decrease in Accounts Payable Decrease in Other Current Liabilities Net Cash Flow from Operating Activities Net Cash Flow from Investing Activities Decrease in Marketable Securities Increase in Property and Equipment Net Cash Flow from Investing Activities Net Cash Flow from Financing Activities Decrease in Notes Payable Increase in Long-Term Debt Increase in Capital Stock (Common Stock + Paid in Capital) Dividends Paid Net Cash Flow from Financing Activities Net Increase in Cash during 2012 Cash at the beginning of 2012 Cash at the end of 2012 Supplementary Disclosure of Cash Flow Information: Cash paid during the year for Interest Income Taxes a. What is Allisha's proper entry for \"Net Cash Flow from Operating Activities? b. What is Allisha's proper entry for \"Net Cash Flow from Investing Activities\"? c. What is Allisha's proper entry for \"Net Cash Flow from Financing Activities\"? d. What is Allisha's proper entry for \"Net Increase in Cash during 2012? e. Since all changes in cash are accounted for in the Statement of Cash Flows, what is the purpose of the \"Supplementary Disclosure of Cash Flow Information\" portion of the statement? Answers: a. b. c. d. e. Chapter 5 Q3 Chapter 5, Question 4 Victor Ortega is the owner of a very successful small company that operates a carry-out pizza parlor. He also prepares his own nancial statements. His task today is the completion of his 2011 Statement of Cash Flows. Using the following Condensed Income Statement and Statement of Retained Earnings for 2011, as well as his 2010 and 2011 Balance Sheets, help Victor complete his Statement of Cash Flows for Year Ending 2011. Then, answer the questions that follow: Ortega's Pizza Condensed Income Statement and Statement of Retained Earnings For the Period: January 1 through December 31, 2011 Income Statement Sales $700,000 Cost of Sales Gross Profit 210,000 490,000 Operating Expenses (excluding depreciation) 388,000 Depreciation Operating Income 14,000 88,000 Interest Income Before Income Taxes 30,000 58,000 Income Taxes (40%) Net Income 23,000 35,000 Statement of Retained Earnings Retained Earnings, December 31, 2010 50,000 Net Income for 2011 35,000 Subtotal 85,000 Cash Dividends Paid in 2011 Retained Earnings, December 31, 2011 20,000 65,000 Ortega's Pizza Balance Sheets December 31, 2010 and 2011 2010 2011 Assets Current Assets Cash Marketable Securities Net Receivables Inventories Total Current Assets 42,000 85,000 93,000 58,000 278,000 965,000 40,000 925,000 Sources Uses 30,000 91,000 80,000 67,000 268,000 Property and Equipment Less Accumulated Depreciation Net Property and Equipment 915,000 30,000 885,000 Total Assets 1,203,000 1,153,000 Liabilities and Owners' Equity Current Liabilities Accounts Payable Notes Payable Accrued Wages Total Current Liabilities 40,000 125,000 38,000 203,000 45,000 150,000 23,000 218,000 Long-Term Liabilities Long-Term Debt Total Liabilities 500,000 703,000 300,000 518,000 Owners' Equity Common Stock Paid in Capital Retained Earnings Total Owners' Equity 75,000 375,000 50,000 500,000 95,000 475,000 65,000 635,000 1,203,000 1,153,000 Total Liabilities and Owner's Equity Total Sources and Uses of Funds Ortega's Pizza Statement of Cash Flows December 31, 2011 Net Cash Flow from Operating Activities Net Income Adjustments to reconcile net income to net cash flows from operating activities Depreciation Decrease in Net Receivables Increase in Inventories Increase in Accounts Payable Decrease in Accrued Wages Net Cash Flow from Operating Activities Net Cash Flow from Investing Activities Increase in Marketable Securities Decrease in Property and Equipment Net Cash Flow from Investing Activities Net Cash Flow from Financing Activities Increase in Notes Payable Decrease in Long-Term Debt Increase in Capital Stock (Common Stock + Paid Capital) Dividends Paid Net Cash Flow from Financing Activities Net Decrease in Cash during 2011 Cash at the beginning of 2011 Cash at the end of 2011 Supplementary Disclosure of Cash Flow Information: Cash paid during the year for Interest Income Taxes a. Did the change in \"Inventories\" reflect a Source or a Use of funds? What was the amount of that change? b. Did the change in \"Long-Term Debt\" reflect a Source or a Use of funds? What was the amount of that change? c. What is Victor's proper entry for \"Net Cash Flow from Operating Activities? d. What is Victor's proper entry for \"Net Cash Flow from Investing Activities\"? e. What is Victor's proper entry for \"Net Cash Flow from Financing Activities\"? Answers: a. b. c. d. e. Chapter 5 Q4