Please respond in Excel to the following two problems: 1. 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. a. At the beginning of the fiscal year, the fund $1,360,000 offset by assigned fund balance in the same amount. b. 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. c. Work contracted for the year amounted to $4,175,000. d. Invoices received for the work performed totaled $4,150,000. $3,980,000 of that amount was paid in cash as of year-end. e. The state reimbursed the city $4,000,000 for the completed work before year-end. 2. Prepare a statement of Revenues, Expenditures, and Changes in Fund Balance for the Roadway Fund. Please respond in Excel to the following two problems: 1. 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. a. At the beginning of the fiscal year, the fund $1,360,000 offset by assigned fund balance in the same amount. b. 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. c. Work contracted for the year amounted to $4,175,000. d. Invoices received for the work performed totaled $4,150,000. $3,980,000 of that amount was paid in cash as of year-end. e. The state reimbursed the city $4,000,000 for the completed work before year-end. 2. Prepare a statement of Revenues, Expenditures, and Changes in Fund Balance for the Roadway Fund