prepare a budget by analyzing a fictional character’s finances, using a cash flow chart. Answers need...

prepare a budget by analyzing a fictional character’s finances, using a cash flow chart.

Answers need to be accurate to the nearest cent.

Expert Solution

Salary Structure	Monthly	Yearly	Exemption	Taxable Salary
Basic Salary	Rs. 59,000.000	Rs. 708,000.000		Rs. 708,000.000
HRA	Rs. 29,500.000	Rs. 354,000.000	Rs. 169,200.000	Rs. 184,800.000
Medical Allowance	Rs. 2,000.000	Rs. 24,000.000	Rs. 15,000.000	Rs. 9,000.000
Transport Allowanace	Rs. 1,200.000	Rs. 14,400.000	Rs. 14,400.000	Rs. 0.000
Performance Pay	Rs. 5,000.000	Rs. 60,000.000		Rs. 60,000.000
Special Allowance	Rs. 15,000.000	Rs. 180,000.000		Rs. 180,000.000

Total	Rs. 52,700.000	Rs. 632,400.000		Rs. 1,141,800.000
			Gross Taxable Salary	Rs. 1,141,800.000

HRA Calculations (Figures in Rs.)
	Actual Rent Paid	Rs. 20,000.000
	HRA	Rs. 29,500.000
Case 1	50% of Basic	Rs. 29,500.000
Case 2	Actual HRA Received	Rs. 29,500.000
Case 3	Actual Rent - 10% of Basic	Rs. 14,100.000
	Lower of the 3 is	Rs. 14,100.000

Deductions
Section 24 B
Interest on House Loan	Rs. 24,000.000	Rs. 24,000.000

Section 80C
PF Deduction	Rs. 84,960.000
Principle on home loan	Rs. 170,000.000
Total Deduction		Rs. 150,000.000
80D
Medical Insurance Premium	Rs. 25,000.000	Rs. 25,000.000


	Net Taxable Income	Rs. 942,800.000

Tax Calculations
Slabs	Tax Rate	Amount
Rs. 0 to Rs. 2.5 Lacs	Rs. 0.000	Rs. 0.000
Rs. 2.5 Lacs to Rs. 5 Lacs	Rs. 0.050	Rs. 12,500.000
Rs. 5 Lacs to Rs. 10 Lacs	Rs. 0.200	Rs. 90,560.000
Above Rs. 10 Lacs	Rs. 0.300
	Total Tax	Rs. 103,060.000

jeff jeffy answered 1 year ago

PREPARE A CASH FLOW USING THE DIRECT METHOD

DIRECT Method RichCorp Income Statement FYE 12/31/19 Revenues 445,000.00 Cost of Goods Sold (232,500.00) Operating Expenses (110,500.00) Interest Expense (6,000.00) Loss on sale of equipment (1,000.00) (350,000.00) Income before income taxes 95,000.00 Income tax expense (32,500.00) Net Income 62,500.00 COMPARATIVE BALANCE SHEET 12/31/2019 12/31/2018 Cash 27,000 18,500.00 Accounts Receivable 34,000 13,000.00 Inventory 27,000 - Prepaid Insurance 2,000 3,000.00 Land 22,500 35,000.00 Buildings 100,000 100,000.00 Equipment 96,500 34,000.00 309,000 203,500.00 Accumulated Depreciation, Buildings 10,500 5,500.00 Accumulated Depreciation, Equipment 14,000 5,000.00 Accounts...

Why do we need to budget for cash flow?

list the steps need to prepare the Cash Flow Statement using the Indirect Method. Which step...

list the steps need to prepare the Cash Flow Statement using the Indirect Method. Which step of the process do you think is the most important? Why?

Prepare a cash budget (using info from the Sales Budget and purchases budget shown below) for...

Prepare a cash budget (using info from the Sales Budget and purchases budget shown below) for January through March and for the first quarter in total. The company maintains a minimum cash balance of $50,000.00, and this was the balance in the cash account on January 1. Past experience shows that 30% of sales are collected in the month of the sale, and 70% in the month following the sale. Labor cost is $15 per unit. Other expenses include $37,000...

1. Cash Flow Statements Prepare a cash flow statement for Anna’s Apples Ltd using the information below....

1. Cash Flow Statements Prepare a cash flow statement for Anna’s Apples Ltd using the information below. Use the indirect method for operating cash flows. Net Profit for year ended 30 June 2017: $200,000 30 June 2017 1 July 2016 Cash ? $20,000 Inventory $30,000 $40,000 Accounts Payable $15,000 $30,000 Unearned Revenue $12,000 $15,000 Prepaid Insurance $18,000 $33,000 Goodwill $50,000 $0 Equipment $300,000 450,000 Acc Dep’n Equipment $150,000 $160,000 Loan Payable $50,000 $100,000 During the year equipment with a cost of $150,000 and accumulated depreciation of $50,000 was sold for $115,000. No other purchases or sales of equipment...

You can determine a company's cash situation by analyzing the cash flow statement. The cash flow ...

You can determine a company's cash situation by analyzing the cash flow statement. The cash flow statement also helps determine whether the company (1) is generating enough cash from its operations to make new investments and pay dividends or (2) will need to generate cash by issuing new debt or selling its assets. A firm has $100 million in revenues. Does that mean it has generated a cash flow of $100 million? No Yes Three categories of activities (operating, investing, and financing) generate or...

How to and an example: 1. Prepare Operating activities for the statement of cash flow using...

How to and an example: 1. Prepare Operating activities for the statement of cash flow using indirect method

There is this Doofus narrative, Prepare a flow chart from it. . The storeroom supervisor checks...

There is this Doofus narrative, Prepare a flow chart from it. . The storeroom supervisor checks the manual inventory perpetual records to identify items that need to be reordered. He prepares a two-part prenumbered purchase requisition [PR] to replenish inventory. The supervisor sends part 1 to the purchasing department, and files part 2 by requisition number.The purchasing department selects a vendor and prepares a five-part prenumbered purchase order [PO]. Part 1 is sent to the vendor. Part 2 is sent...

Prepare a cash flow statement using the indirect method Lomax Income Statement Sales . . ....

Prepare a cash flow statement using the indirect method Lomax Income Statement Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . $2,000,000 Cost of goods sold . . . . . . . . . . . . . . . . . 1,300,000 Gross margin . . . . . . . . . . . . . ....

Using a spreadsheet, prepare a cash budget for New Tech for the next year (January through...

Using a spreadsheet, prepare a cash budget for New Tech for the next year (January through December) based on the following information. OCT NOV DEC Sales revenue (previous year) 325.0 325.0 325.0 Purchases 59.2 (December) PAYMENT SCHEDULE Cash sales 10% 30-day payment = 70% 60-day payment = 20% PURCHASE SCHEDULE Paid in first month = 40% Paid during second 60 days = 60% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sales Revenue 325 300 275...

Question