{"id":78117,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/busn-5200-week-5-homework-assignment-misc-problems"},"modified":"2017-08-18T07:19:40","modified_gmt":"2017-08-18T07:19:40","slug":"busn-5200-week-5-homework-assignment-misc-problems","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/busn-5200-week-5-homework-assignment-misc-problems\/","title":{"rendered":"BUSN 5200 Week 5 Homework Assignment Misc. problems"},"content":{"rendered":"<p>Question 1. Prepare a budget for this year for the Administrative Department at Tom\u2019s Toyota Company based on the following information:<\/p>\n<p>Last Year Forecasting Assumption Budget for this Year<\/p>\n<p>Salaries $60,000 2% increase ___________<br \/> Stationary $ 900 1% decrease ___________<br \/> Telephone $ 2,500 3% increase ___________<br \/> Electricity $ 1,200 2.5% increase ___________<br \/> Office Rent $10,000 2% increase ___________<br \/> Depreciation $ 4,000 no change ___________<br \/> Total: $78,600 ___________<\/p>\n<p>Question 7. Big Bob\u2019s Discount Appliances expects sales of $5,000, $5,000, and $10,000 during April, May, and June (big sale in June). To build business, Big Bob lets all customers buy on credit, and all do so. In the past, 50% of Big Bob\u2019s sales have been collected during the month of sale, 40% are collected the following month, and 10% the month after that. If this trend continues, what will be Big Bob\u2019s total cash collections in the month of June?<\/p>\n<p>Question 8. Little Louie\u2019s expects to have $100 in cash on hand at the beginning of June, and the company\u2019s target cash balance is $100. Net cash flow for June is minus $300. Assuming that Little Louie\u2019s borrows to meet short term cash needs and pays back as soon as surplus cash is available, what will be the company\u2019s ending cash balance after financing at the end of June?<\/p>\n<p>Question 9. Ma &amp; Pa Kettle\u2019s Chili Company has begun selling a new chili recipe and they want you to help them with next year\u2019s budgeted financial statements. Using the worksheet below, complete Ma &amp; Pa\u2019s forecast and answer the questions which follow.<\/p>\n<p>  Assumptions:<\/p>\n<p>To begin with, Ma &amp; Pa are sure sales will grow 50% next year. Assume that is true. Then assume that COGS, Current Assets, and Current Liabilities all vary directly with Sales (that means if sales grows a certain percentage, then the account in question will grow by that same percentage). Assume that fixed expenses will remain unchanged and that $1,000 worth of new Fixed Assets will be obtained next year. Lastly, the current dividend policy will be continued next year.<\/p>\n<p>Ma &amp; Pa Kettle Chili Company, Inc.<\/p>\n<p>Financial Forecast<\/p>\n<p>Estimated<br \/> This year for next year<\/p>\n<p>Sales $10,000 ________<br \/> COGS 4,000 ________<br \/> Gross Profit 6,000 ________<br \/> Fixed Expenses 3,000 ________<br \/> Before Tax Profit 3,000 ________<br \/> Tax @ 33.3333% 1,000 ________<br \/> Net Profit $2,000 ________<\/p>\n<p>Dividends $0 ________<\/p>\n<p>Current Assets $25,000 ________<br \/> Net Fixed Assets 15,000 ________<br \/> Total Assets $40,000 ________<\/p>\n<p>Current Liabilities $17,000 ________<br \/> Long term debt 3,000 ________<br \/> Common Stock 7,000 ________<br \/> Retained Earnings 13,000 ________<br \/> Total Liabs &amp; Eq $40,000 ________<\/p>\n<p>Amount need to balance the balance sheet ________<br \/> (Projected total assets minus projected<br \/> total liabilities &amp; equity *)<\/p>\n<p>* If this number is positive it means Ma &amp; Pa need additional external funding to finance their projected asset growth. If this number is negative it means Ma &amp; Pa have programmed too much financing for the amount of assets they project.<\/p>\n<p>Case Study Tasks:<\/p>\n<p>1. Revise your Financial Overview file based on your instructor\u2019s feedback when received.<\/p>\n<p>2. Begin working on the Ratio Analysis section of your report. Refer to the Case Study topic lecture for this week for specific guidelines.<\/p>\n<p> <i>\u2026<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Question 1. Prepare a budget for this year for the Administrative Department at Tom\u2019s Toyota Company based on the following information: Last Year Forecasting Assumption Budget for this Year Salaries $60,000 2% increase ___________ Stationary $ 900 1% decrease ___________ <a href=\"https:\/\/www.benedictsol.com\/blogs\/busn-5200-week-5-homework-assignment-misc-problems\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-78117","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/78117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=78117"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/78117\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=78117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=78117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=78117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}