Please respond in Excel to the following two problems: Prepare entries in general journal form to record the following transactions in the Roadway Fund general ledger accounts for City of Kettering for the fiscal year 2018

Please respond in Excel to the following two problems: Prepare entries in general journal form to record the following transactions in the Roadway Fund general ledger accounts for City of Kettering for the fiscal year 2018. Use modified accrual accounting. At the beginning of the fiscal year, the fund $1,360,000 offset by assigned fund balance in the same amount. The city was awarded $4,200,000 for road inspections and repairs during the year. The award requires reimbursement for expenditures not an allotment up front. Work contracted for the year amounted to $4,175,000. Invoices received for the work performed totaled $4,150,000. $3,980,000 of that amount was paid in cash as of year-end. The state reimbursed the city $4,000,000 for the completed work before year-end. Prepare a statement of Revenues, Expenditures, and Changes in Fund Balance for the Roadway Fund. Please respond in Word to the following task: Find and provide a link, citation, and written summary of a recent podcast, article, video, or other short media that provides an example (positive or negative) of special funds allocations like Federal Highway Funds or public works project funding like building a new stadium or new community center. An example of such a scenario could be an emergency allocation of federal highway funds to a locality after a natural disaster. Media chosen should be current, dated not before 2016. Include in the summary how the accounting treatment would occur for such allocation.