Part A: Use a spreadsheet to prepare a monthly personal budget to show the available surplus based on the following data. Monthly salary is QAR 14,600. ➤ Monthly rental expense is QAR 6,650. insmniohstn3 eniritol ➤ Food expenses are QAR 250 per week. > Electricity is estimated to be QAR 50 per month. ➤ Ooredoo unlimited usage telephone plan is QAR 320 per month. Entertainment is estimated to be QAR 500 per week. Clothing expenses are estimated to be QAR 5,000 per year. Fuel QAR 50 per week. Insurance QAR 2,460 per year. Vehicle maintenance QAR 2,000 per year. You decide that you must leave a budgeted surplus of QAR 1,000 per month to cover unexpected expenses.

Part A: Use a spreadsheet to prepare a monthly personal budget to show the available surplus based on the following data. Monthly salary is QAR 14,600. ➤ Monthly rental expense is QAR 6,650. insmniohstn3 eniritol ➤ Food expenses are QAR 250 per week. > Electricity is estimated to be QAR 50 per month. ➤ Ooredoo unlimited usage telephone plan is QAR 320 per month. Entertainment is estimated to be QAR 500 per week. Clothing expenses are estimated to be QAR 5,000 per year. Fuel QAR 50 per week. Insurance QAR 2,460 per year. Vehicle maintenance QAR 2,000 per year. You decide that you must leave a budgeted surplus of QAR 1,000 per month to cover unexpected expenses.

Personal Finance

13th Edition

ISBN:9781337669214

Author:GARMAN

Publisher:GARMAN

Chapter3: Financial Statements, Tools, And Budgets

Section: Chapter Questions

Problem 6DTM

See similar textbooks

Similar questions

2019 Sales Cost of Goods Sold Rent Wages Insurance Utilities Auto Maintenance Advertising Other Expenses Total Expenses Net Income Jan 3,250 1,788 525 175 46 220 40 98 2,891 359 Feb 2,700 1,485 525 175 46 225 40 81 2,577 123 Mar 3,855 2,120 525 175 46 285 80 60 116 3,407 448 Tom's Business Income Statement 98 2,900 354 2019 May Jul Aug Sep Oct Nov Dec Total Apr 3,254 3,650 2,850 2,600 2010 2,200 2,250 3,755 4,890 37,264 1,790 2,008 1,106 1,210 1,238 2,065 2,690 20,495 525 525 525 525 525 525 6,300 2,100 175 175 175 175 175 175 46 46 46 46 46 46 550 227 265 210 185 220 230 2,657 40 40 40 80 640 60 147 525 175 46 200 40 110 Jun 588 * º * * * 88 * § 547 1,568 525 175 46 185 80 60 86 3,103 2,724 126 1,430 525 175 46 205 40 78 2,499 101 40 60 2217 (207) 80 60 66 2,372 (172) 68 2,276 (26) 113 3,184 3,952 571 938 240 1,118 34,100 3,164
Please do not give solution in image format ?
Ee 308.
Prepare monthly cash budget from this following information..
Using Marvin's budget, fill in the missing items in the table. Round your dollar answers to the nearest penny. For dollar amounts input the dollar sign followed by the dollar amount. For example: $124.30 Round your percent answer to the nearest whole percent. For percent input the percent followed by the percent sign. For example: 7% In the image.
Please help me
The Brandon household has monthly income of %5,630 on which to base their budget. They plan to save 10% and spend 32% on fixed expenses and 56% on variable expenses. What amount do they plsn to set aside for each budget section in Savings, fixed expenses, and variable expenses?
Prepare a sales budget including a column for each year in and a column for the total. The budgets should also include a schedule of expected cash collection, by year and in total.Make your assumptions about the type of sales (cash versus credit) and your credit terms clear.
I'm working on a budgeted income statement. How do I find the income tax? And what do I do with Estimated Tax Rate:30%?
Round percentages and ratios to the nearest tenth of a percent, dollars to nearest whole dollar. 2. a. ________dollars b. ________ dollars c. ________ dollars d. ________ dollars e. ________ dollars
This is for financial mathematics 2, thank youuuu
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires aminimum cash balance of at least $5,000 to start each quarter.Quarter1 2 3 4 YearCash balance, beginning ............................ $ 6 $ ? $ ? $ ? $ ?Add collections from customers ................. ? ? 96 ? 323Total cash available ................................... 71 ? ? ? ?Less disbursements:Purchase of inventory ............................. 35 45 ? 35 ?Operating expenses ................................ ? 30 30 ? 113Equipment purchases ............................. 8 8 10 ? 36Dividends ................................................ 2 2 2 2 ?Total disbursements .................................... ? 85 ? ? ?Excess (defi ciency) of cash availableover disbursements ................................. (2) ? 11 ? ?Financing:Borrowings .............................................. ? 15 — — ?Repayments (including interest)* ............ — — (?) (17) (?)Total fi nancing…