A while back I posted asample of a corporate balance sheetto use for informal work (e.g. in a classroom). Unfortunately, that version was in Document form, rather than in Excel, so you had to do all the calculations yourself.
This semester, I taught Introduction to Business, wherein students had to complete sample Balance Sheets and Income Statements as part of the ‘intro to accounting’ and ‘finance’ sections in the course. To help with their projects and give them a leg up in the future, I gave them an Excel version of a balance sheet.
I’ve now expanded this file to include:
Balance Sheet
Income Statement
Some General Metrics (e.g. Working Capital, Gross Profit Margin, Inventory Turnover).
If you travel much in Asia, odds are you’ve picked up a Korean Air Skypass membership at some point. Korean Air is one of the better Asian airlines, and their Skypass Club includes a wide variety of team members including Aeroflot, Aerolineas Argentinas, Aeromexico, Air Europa, Air France, Alitalia, China Airlines, China Eastern Airlines, China Southern Airlines, Czech Airlines, Delta Air Lines, Garuda Indonesia, Kenya Airways, KLM Royal Dutch Airlines, Korean Air, Middle East Airlines, Saudia Airlines, Shanghai Airlines, TAROM Romanian Air Transport, Vietnam Airlines, and Xiamen Airlines.
Unfortunately, Korea seems to often use very poor website systems (it’s not just Korean Air), forming websites hard to maneuver around or understand. They’ve also updated and made some changes that makes it hard to understand the mileage claim process. So here are some tips:
Try to get input your number during the ordering process if possible — it’s easiest if Korean Air does the check-in themselves and you don’t need to do anything.
If you fly with an airline OTHER than Korean Air – you’ll need to go through the mileage claim process to carry the miles over. I almost always travel China Southern, so I’m doing this a lot.
SAVE YOUR BOARDING PASS AND E-TICKET! I cannot emphasize this enough. Part of the retro-active process may involve airlines who require additional verification processes (e.g. China Southern) and the Korean Air website glitches a lot, leaving you to input information manually. But that requires you to upload images of your boarding pass and e-ticket. So DON’T LOSE THEM!
Figure out your CLASS ticket. Some boarding passes or tickets will say – some won’t. It dictates the % of your mileage that you can claim, so they sometimes require that you enter that information.
Flights are only valid for 1 year. I lost about 3 years of monthly international flights and thousands of dollars worth of miles because I didn’t realize they would expire (kill me now). Don’t make my mistake!
E) Follow the Instructions and begin entering your data. If your airline is automatically enabled (Korean Air, Air France, KLM Royal Dutch Airlines, Middle East Airlines, Saudi Arabian Airlines, Air Europa, China Eastern, Aerolineas Argentina, Xiamen Air, Vietnam Airlines, Delta Airlines, China Airlines, Garuda Indonesia, Aeromexico), you should be able to do it without a boarding pass / ticket.
F) Some flights require more in-depth detailed data entry. For example: China Southern. . . Small tip – if the website is not working properly for automatic companies (like China Eastern), you can try adding it this way instead. To be honest, this website is a pain in the neck to use.
G) After you have submitted your information, hit confirm and it’ll begin processing! That’s it. . . you may have your miles added automatically, or you may need to wait for them to confirm. But it should go through properly.
Do you remember that old song from when you were a kid?: This sheep looks like the kind of sheep who would sing that song 😛 **He is one of the stone statues at a mansion in Gongyi, Henan, China. Some of the statues are centuries old!
Ba Ba Black Sheep, Have You Any Wool? Yes Sir, Yes Sir Three Bags Full 🎵 One for my Master One for the Maid One for the Little Boy Who Lives Down the Lane 🎵
Everyone is hanging up door signs asking for good things in the coming year. They remain up until next year’s festival. Ours says ‘Blessings’!😂What would yours ask for?
Hey guys! Sorry I’ve been out of contact for a while. My phone decided not to let WordPress app work any more and I don’t have money for a new phone right now. Probably because I use Huawei and they are mad at US and Google right now. Sadness! But I miss my site, so I’ll try posting more often 🙂