1 | 2 | 3 | 4 | 5 | 6 | |
Cost | 70000 | 23400 | 27700 | 14800 | 0 | 0 |
Mark up | 5600 | 1872 | 2216 | 1184 | 0 | 0 |
Billed Value | 75601 | 25274 | 29919 | 15988 | ||
Received | 75601 | 25274 | 29919 | 15988 | 0 | |
Retention 15% | 11340 | 3791 | 4488 | 2398 | 0 | |
40% retention | 8807 | |||||
60% Release of retention | 13211 | |||||
85% relase | 0 | 64260.85 | 21483 | 25431 | 13590 | 0 |
Monthly cash in | 0 | 64261 | 21483 | 25431 | 22397 | 13211 |
Monthly Cash out | -70000 | -23400 | -27700 | -14800 | 0 | 0 |
Total Cumulative Cash Flow | -70000 | 40861 | -6217 | 10631 | 22397 | 13211 |
Net Cash flow after charging previous negative balance | -70000 | -29139 | -35356 | -24725 | -2328 | 10883 |
Fin Charges | -980 | -408 | -495 | -346 | -33 | 0 |
Cash flow after charges | -70000 | 39881 | -6625 | 10136 | 22051 | 13178 |
Show the working Question 1 (7 marks) You are a contractor for a client. Listed as...
Question 18 1 pts The following table provides Acme Corp's transaction for the month. Using the MODIFIED CASH BASIS method and only the transactions listed, calculated the firm's NET INCOME for the month. Enter negative values using the minus sign (e.g.-122) Value 15,869 -400 -800 Transaction Issued shares of capital stock for cash Rented space at a self-storage for 2 weeks paid cash Purchased supplies to be used on a job during this month payment due next month Received a...
Question 18 1 pts The following table provides Acme Corp's transaction for the month. Using the ACCRUAL CASH BASIS method and only the transactions listed calculated the firm's NET INCOME for the month. Enter negative values using the minus sign (e.g.-122) Value Transaction Issued shares of capital stock for cash Rented space at a self-storage for 2 weeks paid cash Purchased supplies to be used on a job during this month payment due next month Received a loan from a...
Question 17 1 pts The following table provides Acme Corp's transaction for the month. Using the MODIFIED CASH BASIS method and only the transactions listed, calculated the firm's NET INCOME for the month. Enter negative values using the minus sign (e.g.-122) Value 12.236 -400 -800 Transaction Issued shares of capital stock for cash Rented space at a self-storage for 2 weeks paid cash Purchased supplies to be used on a job during this month payment due next month Received a...
BAC1034 PRINCIPLES OF FINANCIAL ACCOUNTING QUESTION 1 [10 MARKS] iniri Listed below are business transactions. The company issues ordinary shares in exchange for RM25,000 cash. Purchased RM400 of supplies on credit. Purchased equipment for RM10,000, paying RM3,000 in cash and signed a 30-day, RM7,000, note payable. Real estate commissions billed to clients amount to RM4,000. Paid RM700 in cash for the current month's rent. Paid RM200 cash on account for supplies purchased in transaction 2. Received a bill for RM600...
Reference all values and label them properly on top of your worksheet. No number typed in formulas. Use an Excel file with two worksheets. Use each worksheet for amortization table and one for cash flow table. You are going to buy a car. There is a zero down payment and annual interest rate of 3.5% for the $28,000 car. You will pay back this loan in 7 years, with equal payments at the end of each month. Use a function for...
a. Prepare a schedule of monthly cash receipts for January, February, and March. b. Prepare a schedule of monthly cash payments for January, February, and March. c. Prepare a monthly cash budget with borrowings and repayments for January, February, and March. (Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $0.) Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to...
Islamic finance Murabaha and Istisna'a In a murabaha contract of sale, the client petitions the bank to purchase an item for him/her. ... In a murabaha contract for sale, the bank buys an asset and then sells the asset back to the client with a profit charge. Practice problems Murabaha, Istisna'a Ch 889 Problem 1 Murabaha Mr. Murad is looking to buy a car that costs AED 120,000. He approached 3 Islamic banks and one conventional bank. After discussion with...
You are a management accountant working in the Finance team at Miles private hospital. You have been assigned to assist the ENT (Ear, Nose and Throat) specialists1 that operate out of rented premises on level 6 at the hospital. You are to prepare their master budget for 2021 and make recommendations on how they could improve their operations. There are three (3) ENT Specialists in the practice; Dr Janet Courtney, Dr Samantha Downer and Dr John Malouf. They are supported...
Harry's Carryout Stores has eight locations, The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures: Actual Forecast Additional Information November 360,000 January 440,000 April forecast December 380,000 February480,000 $420,000 March 430,000 Of the firm's sales, 50 percent are for cash and ther...
Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures Actual Forecast Additional Information November $560,000 January S640,000ADr December 580,000 February 680,000 $520,000 forecast March 530,000 Of the firm's sales, 50 percent are for cash and the remaining...