Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Week Five Project Problem Two a. Using the information provided, construct a monthly cash budget for July through September 2023. Based on your analysis, will
Week Five Project Problem Two a. Using the information provided, construct a monthly cash budget for July through September 2023. Based on your analysis, will TopNotch Technology enjoy a surplus of cash, or require external financing? What is the amount? Enter the amount in cell J3. b. Construct a pro forma income statement for the first fiscal quarter of 2023 (July through Sept. 2023). Express the amounts in the same manner (thousands) as illustrated in the June 30th income statement. Hint: Apply a denominator of 1,000 where appropriate in the pro forma income statement. TopNotch Technology Corp. Facts and assumptions Sales (20 percent for cash, the rest on 30-day credit terms): 2023 Actual April 87,000 D Purchases (all on 60-day terms): 2023 Actual April 120,000 May 103,000 Sheet1 May 142,000 Principal payment on debt due in September Interest due in September Salaries payable monthly --- 7 June 245,000 ady Accessibility: Investigate June 225,000 July 145,000 July 69,000 2023 Projected August 76,000 2023 Projected August 42,000 25,700 12,000 30,000 10.000 September 106,000 September 38,000 a. Cash receipts: Sales for cash Collections from credit sales Total cash receipts Cash disbursements: Payment for purchases Salaries Interest payments Principal payments Dividends Tax payments Total cash disbursements
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started