《Excel在財務中的套用》是2023年電子工業出版社出版的圖書，作者是高曉林。
基本介紹
- 中文名：Excel在財務中的套用
- 作者：高曉林
- 出版社：電子工業出版社
- 出版時間：2023年3月
- 頁數：264 頁
- 定價：59.0 元
- 開本：16 開
- ISBN：9787121451034
內容簡介,作者簡介,圖書目錄,
內容簡介
本教材共十二章，第一章介紹了Excel基礎知識，第二章和第三章結合會計工作的賬務處理程式，第四章介紹了Excel在薪酬管理中的套用第五章介紹了Excel在應收賬款管理中的套用，第六章介紹了Excel在存貨管理中的套用，第七章介紹了Excel在固定資產管理中的套用，第八章介紹了Excel在成本費用管理中的套用，第九章介紹了Excel在本量利分析中的套用，第十章介紹了Excel在投資決策中的套用，第十一章介紹了Excel在籌資決策中的套用，第十二章介紹了Excel在財務分析中的套用。
作者簡介
高曉林 女，西安財經大學商學院會計系教授，陝西省審計廳特約審計員。主持或參與國家社科基金項目、中國總會計師協會、陝西省教育廳、陝西財政廳、陝西省社科聯重大理論和現實問題研究等多項課題，在《中南財經政法大學學報》、《生產力研究》、《財會月刊》等學術期刊發表論文30餘篇，作為主編在西安交通大學出版社、立信會計出版總社等出版《高級財務會計》教材數版。
圖書目錄
第一章 Excel 基礎知識 ··························································································.1
第一節 Excel 認知·······························································································.2
一、數據輸入與編輯 ·······················································································.2
二、數據管理與分析 ·······················································································.6
第二節 Excel 常用公式與函式 ···············································································.14
一、Excel 常用公式 ·······················································································.14
二、數學與統計函式 ······················································································.18
三、邏輯與文本函式 ······················································································.19
四、日期與時間函式 ······················································································.20
本章實訓 ···········································································································.21
第二章 Excel 在憑證與賬簿中的套用 ····································································.23
第一節 記賬憑證的編制 ······················································································.24
一、創建記賬憑證·························································································.27
二、編輯記賬憑證·························································································.32
三、最佳化憑證號····························································································.35
四、輸入後續憑證數據 ···················································································.37
第二節 日記賬的生成 ·························································································.38
一、設定現金日記賬格式 ················································································.38
二、登記現金日記賬 ······················································································.39
第三節 科目匯總表的生成 ···················································································.42
一、設定科目匯總表格式 ················································································.42
二、獲取本期發生額 ······················································································.42
第四節 總分類賬的生成 ······················································································.48
一、設定總分類賬格式 ···················································································.48
二、錄入期初數····························································································.50
三、計算總賬科目本期發生額 ··········································································.50
四、計算期末數····························································································.51
本章實訓 ···········································································································.52
第三章 Excel 在財務報表中的套用········································································.53
第一節 資產負債表的編制 ···················································································.54
一、設定資產負債表格式 ················································································.54
二、獲取一級科目期初數 ················································································.56
三、計算資產負債表期初數 ·············································································.59
四、獲取發生額····························································································.61
五、計算資產負債表期末數 ·············································································.64
第二節 利潤表的編制 ·························································································.66
一、設定利潤表格式 ······················································································.66
二、獲取本期發生額 ······················································································.66
三、計算利潤表本期金額 ················································································.69
本章實訓 ···········································································································.71
第四章 Excel 在薪酬管理中的套用········································································.74
第一節 員工信息表的編制 ···················································································.75
一、創建參數表····························································································.76
二、創建員工信息表 ······················································································.77
三、添加員工信息·························································································.84
第二節 考勤表與業績表的編制··············································································.84
一、編制考勤表····························································································.86
二、編制業績表····························································································.88
第三節 員工工資表的編制 ···················································································.91
一、創建員工工資表 ······················································································.91
二、計算“五險一金” ···················································································.95
三、計算個人所得稅 ······················································································.99
四、計算實發數····························································································100
第四節 工資條的編制 ·························································································101
一、生成工資條····························································································101
二、列印工資條····························································································101
本章實訓 ···········································································································103
第五章 Excel 在應收賬款管理中的套用·································································105
第一節 應收賬款的分析 ······················································································106
一、編制應收賬款統計表 ················································································106
二、分類匯總應收賬款 ···················································································109
三、繪製應收賬款三維餅圖 ·············································································113
第二節 逾期應收賬款的分析·················································································117
一、編制逾期應收賬款表 ················································································117
二、繪製逾期應收賬款簇狀柱形圖 ····································································120
三、編制應收賬款催款函 ················································································123
第三節 應收賬款的賬齡分析·················································································129
一、編制應收賬款賬齡分析表 ··········································································129
二、計算應收賬款壞賬準備金額 ·······································································130
本章實訓 ···········································································································131
第六章 Excel 在存貨管理中的套用········································································133
第一節 進貨的統計分析 ······················································································134
一、創建存貨參數表 ······················································································134
二、創建入庫單界面 ······················································································135
三、編制入庫統計表 ······················································································137
第二節 銷貨的統計分析 ······················································································141
一、創建出庫單界面 ······················································································141
二、編制出庫統計表 ······················································································143
第三節 存貨的分類匯總 ······················································································146
一、創建存貨匯總表 ······················································································146
二、計算總金額和總數量 ················································································147
本章實訓 ···········································································································150
第七章 Excel 在固定資產管理中的套用·································································151
第一節 固定資產的登記與變更··············································································152
一、登記固定資產·························································································152
二、變更固定資產·························································································159
第二節 固定資產的折舊處理·················································································163
一、創建固定資產折舊錶 ················································································164
二、年限平均法計提折舊 ················································································165
三、雙倍餘額遞減法計提折舊 ··········································································166
四、年數總和法計提折舊 ················································································167
五、分析折舊費用·························································································168
本章實訓 ···········································································································171
第八章 Excel 在成本費用管理中的套用·································································172
第一節 產品成本的統計分析·················································································173
一、創建產品成本計算表 ················································································174
二、計算產品成本·························································································174
三、分析產品成本差異 ···················································································182
第二節 日常費用的統計分析·················································································185
一、創建參數表····························································································185
二、創建費用匯總報銷單 ················································································187
三、編制日常費用統計表 ················································································188
四、按費用類別分析日常費用 ··········································································191
五、繪製日常費用分析圖 ················································································193
本章實訓 ···········································································································196
第九章 Excel 在本量利分析中的套用 ····································································199
第一節 分解混合成本的方法·················································································200
一、利用圖表工具分解混合成本 ·······································································200
二、利用相關函式分解混合成本 ·······································································203
第二節 本量利關係的敏感分析··············································································203
一、計算單品種盈虧平衡點 ·············································································204
二、分析單品種敏感性 ···················································································205
三、繪製單品種本量利分析動態圖表 ·································································206
四、計算多品種盈虧平衡點 ·············································································210
本章實訓 ···········································································································212
第十章 Excel 在投資決策中的套用········································································213
第一節 貨幣時間價值的認識·················································································214
一、計算現值·······························································································214
二、計算終值·······························································································216
三、計算利率·······························································································217
第二節 投資決策指標的計算·················································································218
一、靜態評價指標·························································································218
二、動態評價指標·························································································221
本章實訓 ···········································································································224
第十一章 Excel 在籌資決策中的套用 ····································································226
第一節 資金需要量的預測 ···················································································227
一、資金習性法預測 ······················································································227
二、銷售百分比法預測 ···················································································230
第二節 資本成本的測算 ······················································································234
一、創建資本成本計算界面 ·············································································234
二、計算個別資本成本 ···················································································235
三、計算加權資本成本 ···················································································236
第三節 長期借款籌資的決策分析···········································································238
一、編制等額本息法貸款還本付息計畫表 ···························································238
二、編制等額本金法貸款還本付息計畫表 ···························································241
本章實訓 ···········································································································242
第十二章 Excel 在財務分析中的套用 ····································································244
第一節 財務結構分析 ·························································································245
一、分析資產負債表結構 ················································································247
二、分析利潤表結構 ······················································································249
第二節 財務趨勢分析 ·························································································251
一、繪製資產趨勢線 ······················································································251
二、計算增長率····························································································252
第三節 財務指標分析 ·························································································252
一、分析償債能力·························································································252
二、分析營運能力·························································································254
三、分析盈利能力·························································································255
四、分析成長能力·························································································256
本章實訓 ···········································································································256
