Download trong đây mô tả cách làm bài của môn tài chính trong du lịch hy vọng giúp được bạn rất nhi and more Summaries Agricultural Mathematics in PDF only on Docsity! 32001293_Lê Huyền Trân_ Quản trị tài chính trong du lịch_N01 Bài làm 1. Wowy Tourism Corporation uses 800,000 tons of rice per year. The carrying costs are $80/ton. The cost per order is $60. a/ Calculate the economic order quantity per order? b/ Calculate the optimal number of orders per year? c/ Calculate the total costs of optimal inventory? a) EOQ = √ 2 .800,000 .60 80 = 1095,45 tons b) Optimal Number of Orders = Sale / EOQ Optimal Number of Orders = 800,000 1095,45 = 730,29 order c) Total order cost = 730,29. 60 = 43,817 Total carrying cost = 43,817,61 2 .80 = 43,818 =>Total inventory turnover = Total order cost + Total carrying cost = 43,818+ 43,817 = 87,635 2. The Tourism Corporation has presented the following information 2XX1 2XX2 Current Assets Cash $ 7,800.00 $ 7,300.00 Marketable Securities $ 7,500.00 $ 7,500.00 Accounts Receivable $ 25,000.00 $ 24,000.00 Inventories $ 10,400.00 $ 12,000.00 Prepaid Expenses $ 2,500.00 $ 2,600.00 Total Current Assets Current Liabilities Accounts Payable $ 4,400.00 $ 4,200.00 Accrued Expenses $ 3,600.00 $ 5,600.00 Current Tax Payable $ 4,500.00 $ 3,400.00 Deposits and Credit Balances $ 700.00 $ 400.00 Current Portion of Loan $ 10,700.00 $ 9,500.00 Total Current Liabilities Revenue $ 500,000.00 Credit Sales Cost of Good Sold $ 380,000.00 Revenue for the year 2XX2 was $500,000 (38% of this was credit sales) and the cost of good sold was $380,000. Required: a/ For both years calculate the working capital? 2XX1, 2XX2 b/ For both years calculate the current asset ratio? 2XX1, 2XX2 c/ Calculate the account receivable turnover? Calculate the account receivable collection period ? d/ Calculate the inventory turnover? Calculate days in inventory? a) 2XX1 *CA = Cash + Marketable Securities + Accounts Receivable + Inventories + Prepaid Expenses = 7,800.00 + 7,500.00 + 25,000.00 + 10,400.00 + 2,500.00 = 53,200.00 *CL = Accounts Payable + Accrued Expenses + Current Tax Payable + Deposits and Credit Balances + Current Portion of Loan = 4,400.00 + 3,600.00 + 4,500.00 + 700.00 + 10,700.00 = 23,900.00 NWC = CA – CL = 53,200.00 - 23,900.00 = 29,300.00 2XX2 *CA = Cash + Marketable Securities + Accounts Receivable + Inventories + Prepaid Expenses = 7,300.00 + 7,500.00 + 24,000.00 + 12,000.00 + 2,600.00 = 53,400.00 *CL = Accounts Payable + Accrued Expenses + Current Tax Payable + Deposits and Credit Balances + Current Portion of Loan = 4,200.00 + 5,600.00 + 3,400.00 + 400.00 + 9,500.00 = 23,100.00 NWC = CA – CL =53,400.00 - 23,100.00 = 30,300.00 b) Current asset ratio (2XX1) = CA CL = 53,200.00 23,900.00 = 2,23 *Current asset ratio (2XX2) = CA CL = 53,400.00 23,100.00 = 2,31 *Long term assets = Building + Equipment = 55,000 +15,000 + 70,000 *Borrowed amount = 50% of total long term assets = 50%*70,000 = 35,000 *TL = Payable to suppliers + Borrowed amount = 37,000 + 35,000 + 72,000 *TA = Building + Inv + Equipment + AR + Cash = 95,300 *Shareholder’s equity = TA – TL = 23,300 GGG Tourism Service Corporation Balance Sheet As of 31/12/20XX Assets Building: 55,000 Inventories: 8,000 Equipment: 15,000 AR: 5,300 Cash: 12,000 Total assets: 95,300 Liabilities Payable to suppliers: 37,000 Borrowed amount: 35,000 Total liabilities: 72,000 Shareholder’s equity: 23,300 Total liabilities and equity: 95,300 8. "Prepare the short balance sheet using the following DVH Tourism Corporation’s financial data: a. Owner contributes $1,992,000 cash to commence business. b. Purchased a van for $382,000 ; paying $282,000 in cash and obtaining a loan for the balance. c. Purchased game equipment stock on credit for $100,000. d. Billed clients $121,000 for tours. e. Received $98,000 from customers billed in (4) above. f. The accountant has determined that $63,600 of inventory stock has been used. g. Paid $51,200 for miscellaneous expenses (telephone, electricity, etc.). h. Repaid 80% of the loan taken out for the van. i. Other long-term debt $6,200. Cash: 1,992,000 Van: 382,000 Pay cash for van: 282,000 Loan for van: 100,000 Loan (game equipment); 100,000 AR from clients: 121,000 Clients pay: 98,000 AR = 23,000 Use inventory: 63,600 Expenses: 51,200 Repaid 80% Loan Van: 80%. 100,000 = 80,000 Loan Van: 20,000 Long-term debt: 6,200 Cash = 1,992,000 - 282,000 + 98,000 - 80,000 - 51,200 = 1,676,800 Inventory = 100,000 Assets Cash: 1,676,800 AR: 23,000 Inventory: 364,000 Total Curent Assets: 1,736,200 Long-term assets (Van): 382,000 Total assets: 2,118,200 Loan (Game equipment): 100,000 Loan (Van): 20,000 Long-term liabilities: 6,200 Total liabilities = CL + Long-term liabilities =126,200 Total equity = TA – TL = 1,992,000 =>Total liabilities and equity = TL + TE = 2,118,200 6. Tom's Toys is currently experiencing a bad debt ratio of 6%. Tom is convinced that, with tighter credit controls, he can reduce this ratio to 2%; however, he expects sales to drop by 8% as a result. The cost of goods sold is 75% of the selling price. Per $100 of current sales, what is Tom's expected profit under the proposed credit standards? The current bad debt ratio is 6%, which means Tom expects to lose $6 for every $100 in sales. The proposed new bad debt ratio is 2%, which means Tom expects to lose $2 for every $100 in revenue. The expected decrease in revenue is 8%, which means new revenue will be 92% of current revenue. Cost of goods sold is 75% of selling price, which means gross profit is 25% *Expected profit per $100 of current revenue: (0,92 * 0,25 * 100) - (0,06 * 100) - (0,02 * 92) = 22,8 - 6 - 1,84 = 14,96 USD 7. The default rate of Don's new customers has been running at 20%. The average sale for each new customer amounts to $500, generating a profit of $200 and a 30% chance of a repeat order next year. The default rate on repeat orders is only 5%. If the interest rate is 6%, what is the expected profit from each new customer? *Revenue = sales = 500 *Profit = 200 =>Cost = 300 *Interest rate (r): 6% 1st order = 1 – p = 20% p = 80% *Repeated order = 1 – p = 5% p = 95% *Chance of a repeat: 30% Expected profit 1st order = 80% x 200 – 20% x 300 = 100 Expected profit repeated order = 95% x 200 – 5% x 300 = 175 Expected profit = 100 + 30% x 175 1+6 % = 149,53 8. In the last financial year AAA Tourism Corporation achieved a revenue of $49.12million and a gross profit margin of 40%. Its end-of-quarter inventory balance were as follows: Quarter Inventory 1 $ 800,000.00 2 $ 900,000.00 3 $ 900,000.00 4 $ 700,000.00 Required: a/ Calculate the corporation’s inventory turnover and the average day of inventory? b/ Comment on AAA Tourism Corporation’s liquidity, assuming most of its competitors (BBB Corp) record an inventory turnover of 65?